Copy Recordset into array?

  • Thread starter Thread starter Andrew_blue
  • Start date Start date
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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting ADODB recordset into unopened workbooks 3
Pasting ADODB recordset into unopened workbooks II 3
Problem copying ADO recordset to Excel 2003 2
Copying recordset multiple times using copyfromrecordset 5
VBA SQL Select for Column Name 1
CopyFromRecordset Question 4
CopyFromRecordset Error If More Than 911 Characters 6
sql stored procedure results in a recordset questions 2

Back
Top