Very Computer

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
fields?

I would really appreciate the help. This is really getting to me.

The INPUT Statement in VB reads text files that are comma delimited.
Furthurmore, if the the field is a String, then it must be enclosed in
double quotes (Strings can have commas in them but not double quotes).

I suggest 2 things you can do: 1) Use a Word Processor to edit the
text file or 2) Read the entire line in to VB and separate the fields
with code.

Quote:>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
>fields?
>I would really appreciate the help. This is really getting to me.

Quote:

> 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
> fields?

Note the SCHEMA.INI needs to be in the same directory as the text file.

I would post some code, but I left it at work.
--
Dave Mathias