On 11/07/2010 03:16, Kelii wrote:
Kelii,
Have you looked at
http://support.microsoft.com/kb/278973
There is a downloadable file ExcelADO.exe
The text contains the following:
"7. Click Sample 4. This sample produces the same results as Sample 1,
but the technique that is used to transfer the data is slightly
different. In Sample 1, records (or rows) are added to the worksheet one
at a time. Sample 4 adds the records in bulk by attaching the Excel
table to an Access database and running an append query (or INSERT
INTO..SELECT FROM) to append records from a table in the Access table to
the Excel table. Once the transfer is complete, the Excel table is
detached from the Access database and the workbook that results is
displayed in Excel. Quit Excel, and return to the Visual Basic application."