I have asked this question several times but no one has yet to respond so I thought I would rephrase it a little..

When inserting data from a text file into an Access DB table using ADO, it performs very slowly.

But, when using Access's built in Import utility, it literly takes seconds for a 5,000 row text database to be completely imported into the Access table. But using an ADO loop to perform the same function, it takes about 5 minutes.

My question is, is there any way to utilize Access's Import utility from within VB6 in order to achieve those brake neck speeds that Access is capable of? Access wont be installed on the end user's machines, so will that be an issue? Or, is there something better that I can do instead of the following to increase performance:


For i = intCntr to 5000

adoPrimaryRS!Field1 = "test"
adoPrimaryRS!Field2 = "test"

Next

The above code takes about 5 minutes but Importing a 5,000 row text file into Access directly takes seconds.. Shouldn't I be able to match that performance from within VB?

Any help or guidance would be appreciated..

Dan