Specify carriage return / ignore line feed as record delimiter

T

TGorelick

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?
 
J

John Nurick

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 add a carriage return, line feed inside a memo field7 1
Keeping Format Importing From Excel 4
Change carriage return to a line feed 1
Import txt file - records on multiple lines 1
Import soft returns in Memo field 0
Odd character display (ASCII 128-159) 1
removing carriage returns and line feeds 4
adding a Carriage Return or Line Feed character to an update query 3

Top