Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Record Set To Sheet
I am wondering the easy way to take data retrieved from a database, which is
now sitting in a record set, and place that data into the sheet. Do I need to itterate through the record set and navigate cell by cell of my sheet, or is there a quicker way to get all the data loaded into a specific area of my sheet Thanks in advance for your assistance!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Record Set To Sheet
Hi
Use the CopyFromRecorset method of the Range object. Say you want to paste your recordset starting in A1: Dim Rst as adodb.recordset ... Range("A1").CopyFromRecordset Rst done! The syntax is Range.CopyFromRecorset Recordset, MaxRows, MaxColumns -- Regards, Sébastien <http://www.ondemandanalysis.com "Jim Heavey" wrote: I am wondering the easy way to take data retrieved from a database, which is now sitting in a record set, and place that data into the sheet. Do I need to itterate through the record set and navigate cell by cell of my sheet, or is there a quicker way to get all the data loaded into a specific area of my sheet Thanks in advance for your assistance!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
How to record a sheet change showing row column sheet name and date? | Excel Programming |