Copy Recordset into array?

A

Andrew_blue

I have been pulling recordsets out of Access tables using the DAO mode
and pasting them into workbooks using the CopyFromRecordset method.

I would like to load the recordset right into an array, bu
CopyFromRecordset method requires a range object.

Can anyone suggest another method that can be used to drop a recordse
into an array
 
B

Bob Phillips

Andrew,

I don't use DAO, I use ADO, so this might not work, but ADO has a GetRows
method

myArray = oRS.GetRows()

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top