How to speed up Bulk Insert?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
siddahuja said:
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
Click to expand...

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