I am using VB6 and ADO to connect to an Access97 database, and need to import some text into the database. This is easy to do in Access, using the TransferText command.
However, via VB6, I am not sure how to do this. I can certainly connect to the text as a source, and open a recordset, but it is not formatted correctly (it is comma delimited instead of Tab).
Is there some other way of using VB to a get text file into the Access database. Any suggestions will be most welcome.
Chris
