Can't get a right file when exporting.

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

Guest

Hi,
I should export my DB table to CSV format file but the problem is there are
"end of lines" in the table fields. As result the CSV file is mixed.
Please help me solve the problem.

Thanks a lot.
 
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?
 
Back
Top