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)
"Andrew_blue " wrote in message
...
I have been pulling recordsets out of Access tables using the DAO model
and pasting them into workbooks using the CopyFromRecordset method.
I would like to load the recordset right into an array, but
CopyFromRecordset method requires a range object.
Can anyone suggest another method that can be used to drop a recordset
into an array?
---
Message posted from http://www.ExcelForum.com/