Text File Link
Posted on 2000-03-31
I am trying to link a large text file (delimited with a pipe sign field delimeter). The file is first being FTPd as a text file from one server to another using a UNIX FTP process. This is placing a end of record marker (a bold vertical bar similar to a pipe sign) after each text record (approx 80 chars and 15 fields). The MS ACCESS link wizard is enterpreting properly as a delimeted text file but somehow the end of record marker is causing ACCESS to conclude that the text file is just one long text record; therefore the link wizard fails because it exceeds a single record size maximum. The text file needs to be delimited vs fixed because some of the fields may be blank. Is there a way in ACCESS to deal with this end of record marker so the link wizard will work? If not, can the UNIX FTP process be reset to drop the end of record marker?