Help Inserting data into a range of cells

  • Thread starter StuckInTheMiddl
  • Start date
S

StuckInTheMiddl

Hi, I'm trying to use Excel 2000 VBA with ADO.

I have a ADO recordset that i would like to insert into a range on a
worksheet. Each row in my recordset exactly matches the columns.

I know i loop through my recordset and insert my values 1 cell at a
time for each record, but this seems extremely slow especially when
1000s of records come back from my database call.

I would like know if there is some way to add/paste my entire 1500 rows
from my recordset into a range in one go?

Am i just chasing a pipe dream here or is this possible using VBA?


-Thanks, -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CopyFromRecordset with Filtered ADO recordset 2
ADO retrieval from close workbook-data type issue 2
VBA set thick borders around non empty cells in range 0
Trasfer data to SQL Server 5
ADO Recordset Filter for alpha 4
Problem creating PivotTable from ADO recordset using VBA 0
What is the fastest way to pull a recordset using ADO to Oracle. 1
Retrieving Pipe (|) delimited text file into ADO Recordset 2

Top