Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting ADODB recordset into unopened workbooks
Hi,
I'm trying to paste data into a workbook from an ADODB recordset using ..CopyFromRecordset rsData. However, I'd prefer not to open the target workbook, because this slows things down a lot (when executed on 50+ files). Is there a way to use .CopyFromRecordset rsData with an unopened workbook? Or alternatively, is there a way I can set up a connection to the targetfile and use an "Insert * From" string to refer to a variant array? In other words, is there a way to: create the ADODB recordset from the source file, paste the data into thisworkbook and create a vaData from this, which is then used as "VALUES(vaData)" in the insert connection string? (I've gotten as far as pasting the data and creating the vaData, but I can't get it to work in the insert string.) Many thanks for any tips. Regards, JvL |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADODB.Recordset from workbooks : numbers only? | Excel Programming | |||
ADODB Recordset Function | Excel Programming | |||
0 with ADODB Recordset | Excel Programming | |||
adodb.recordset with excel | Excel Programming | |||
ADODB Recordset | Excel Programming |