Assume that I have a text file which is comma delimited and has 5 fields. Assume also
that I do not need to manipulate any of the data and that I want to import the complete
text file into an Access DB table which also has 5 fields. The 5 fields in the text
file are in the same order as the 5 fields in the Access DB so again, I do not have
to do any manipulation.

Here's what I'm currently doing:.

I am reading in the text file and splitting the fields up into an array. I'm then
using that array and looping through and inserting each field into the Access table via
ADO such as:

adoRS!ID = Array(0)
adoRS!Name = Array(1) and so on..

HOWEVER, it is way too slow when there are 1,000's of records.

My question is, is there any function available via VB6 which will allow me to quickly
transfer the text file into the Access table? In other words, I want to mimic the Import
text feature that's built into Access because it is super fast.. Some things to keep in mind.. I do not want to do this in Access.. I need to do in via VB6. Access will not be installed on the user's machine, just the .mdb file with VB6 as the front end.

Any and all help would be appreciated..

Dan