Specify carriage return / ignore line feed as record delimiter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have source data that includes line feeds which are not intended to be
record delimiters. Is there a way to include line feeds in text data
imported into Access 2003 memo fields? The import wizard treats all line
feeds as record delimiters. Alternatively, if I substitute a placeholder
character for the line feeds ("soft returns") in the text file, how can I
easily replace the placeholders with LF's after the data has been imported?
 
AFAIK the only text file format that reliably handles carriage returns
or line feeds within the data is "CSV": fields are separated by commas,
and text fields are delimited (qualified) by quote marks. Any quote
marks in the data must be doubled.

Remember that Access 2003 requires Windows-style text files (with
carriage return+line feed as record separator). The standard Access
textbox control also requires CR+LF for a line break: there's no concept
of "soft returns" and a LF on its own shows up as a "box" character. So
you'd need to replace your placeholder with Chr(13) & Chr(10).
 
Back
Top