I am using vb6 and sql server 2000.
I have a program to import several tables from one server to another using vb6. I am using "INSERT" to add new records one by one. But when the table gets larger, the project is really slow to finish the process.

Can anyone give me any advise how to speed up the process?

Thanks a lot.