I am looking for a code sample and/or good explination about how to convert a delimited text file into a .mdb format by opening the text file using the dbengine and also opening the .mdb file with the dbengine, reading one record at a time from the text file and filling in the .mdb file.
I have tried several times to make the schema.ini file work but it is returning unexpected results every time even though I am vurtully copying the code from the help file.
The text file is being delimited with the pipe character "|" but another printable character can be used if that is causing the problem. Although I have tried several other characters too such as Tilde "~" and even the exclamation point "!" and get the exact same results.
I get 1 of 2 results...
1, The parse doesn't work and I get 1 field in each record that includes the delimiter character I am using instead of several fields in each record.
2, An error to the effect "filename" is an invalid file name. and this makes no sence to me.
Any help would be greatly appreciated.