View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Copy Recordset into array?

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/