ACCESS 97 - Record delimiter

[BCONNER]

When importing data can you define a custome record delimiter? The data I am trying to import has a different record delimiter that the standard CR LF.

 

[bitbrain]

My only thought is to write a VBA program to read, convert, and rewrite the text file. Use Open with a record length of 1 or 2, check for your delimiter and substitute CR LF(Chr$(13) + Chr$(10)) then re-write the file with Write or Put. Then Import...<br>
<br>
Working with text files can be awkward with VB. There may be other tools that are better. VideoSoft's (

http://www.videosoft.com)

vsAwk might work for you. If I'm not mistaken Awk is a Unix string parsing command. vsAwk is an OCX equivalent of this powerful tool.<br>