community.borland.com

Article #25597: Using CR/LF with an external file

Problem:
I know about the External Table functionality of Interbase, but the CR/LF
issues is a set back. Because if I understand correctly, you have to 
create/modify the table to accommodate for the CR/LF.

Solution:
the CR/LF is not required in an external file.  The only reason you
would want to add it would be if:

1) other applications accessed the file and required each row on a 
     separate line
2) you wanted to be able to view the file

If you are just using the external file as a temp table to modify your
internal file the CR/LF isn't necessary.

Last Modified: 26-OCT-00