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, -


---
Message posted from http://www.ExcelForum.com/

The CopyFromRecordset method should do this for you.

--

Vasant



"StuckInTheMiddl " wrote in
message ...
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, -


---
Message posted from http://www.ExcelForum.com/