Posted to microsoft.public.excel.programming

Andrew_blue Andrew_blue is offline

external usenet poster

Posts: 1

Copy Recordset into array?

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

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy recordset from an Access "make table" query	Laurie[_4_]	Excel Programming	1	February 5th 04 09:45 AM
Pass an ADO recordset	Quartz	Excel Programming	5	December 31st 03 04:07 PM
Creating small "recordset" or sorting a numeric 1-dim array	Anthony Cravero	Excel Programming	0	December 19th 03 06:36 PM
Recordset	Stephan Kassanke	Excel Programming	0	September 10th 03 04:45 PM
ADODB Recordset	Seth[_3_]	Excel Programming	0	August 5th 03 02:15 PM

All times are GMT +1. The time now is 08:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us