>>Unfortunately the way these files are designed there are both carriage returns and linefeeds embedded in the row.
>>
>>It is an SDF file of variable length but always has a carriage return followed by a line feed at the end of each line.
>>
>>Is there a way to deal with this?
>
>CR+LF is the standard end-of-line symbol in the DOS/Windows world.
>
>APPEND FROM, or IMPORT, should deal with this correctly.

I'm getting a line break on Line Feeds. I'll set up a test to verify.