How to speed up Bulk Insert?

[Guest]

Hi

I have a table with 1710 records. I used the ado GetRows() function to dump
all the data into a variant variable.

Now i would like to grab all the data and insert it into another table.

I used ado to create a new recordset for the table and using do loop to go
through the variant variable to insert it. This takes around 4 minutes to do
it, whereas getrows() is instant.

Is there a way to speed up the bulk inserts?

thanks
sid

 

[Justin Hoffman]

Hi

I have a table with 1710 records. I used the ado GetRows() function to
dump
all the data into a variant variable.

Now i would like to grab all the data and insert it into another table.

I used ado to create a new recordset for the table and using do loop to go
through the variant variable to insert it. This takes around 4 minutes to
do
it, whereas getrows() is instant.

Is there a way to speed up the bulk inserts?

thanks
sid

In general, running an append query will be the fastest possible way.
Simply adding 1710 records could take under a second!