I have read the documents and help files in VB and still can't get this
one to work properly.
I am trying to read in a text file (several actually) and convert them
into .mdb format data files.
The files all have headers with the field names and are delimited by a
pipe character "|" between each field.
I keep getting an error that reads something like ("filename" is an
invalid file name) each time I try to open the text file. Or if I don't
use a custom schema.ini file then I get one larg field with all of the
fields including the delimiter because the Jet DBengine doesn't know what
the delimiter is.
Anyone have a short and simple way to read in every record from a text
file delimited in this manner and write out to a .mdb table with the same
I would really appreciate the help. This is really getting to me.