Microsoft Access - New Line Dlimiter

Access only allows a single character for a delimeter. I even tried using an alt command for it, but it doesn't recognize the carriage return.

What kind of file would you want to read in each line as a seperate field? If it's a short file, you could edit the file manually by adding a delimeter, if it's a long file, you do have a limit on the number of fields allowed in a table.

Since this is a VB forum how about old Input# or READ #1 ... ?

Its a standard way.

THUS:
Open for Input as 1
While not eof
Input #1
... your code goes here.
Wend

I think this will do you.

HTH

End of mail.