Hi Anat,
In the CSV files that Access creates, text fields are "qualified"
(delimited) by being enclosed in quotation marks, e.g.
123,"John","Smith","Another field"
If there's a line break within a value, the CSV file is like this:
123,"John","Smith","First line
Second line"
Unfortunately, not all software that reads CSV files can handle this. In
other words the problem is with your software that's reading the file,
not with Access. It should be possible to work round the problem, but
more information is needed. For example:
- Can the other software read Excel or dBase files? If so, that's the
simplest thing: just export in that format.
- Do you need to preserve the line breaks in the data, or can you just
replace them with spaces or other characters?
- Are the fields that contain the line breaks text fields or memo
fields?