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

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