Help Inserting data into a range of cells
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/ |
Help Inserting data into a range of cells
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/ |
All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com