J
JVLin
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
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