13 Jul
2004
13 Jul
'04
1:56 p.m.
On Monday 12 July 2004 22:59, John Lange wrote:
if there are any text or memo fields in Access that happen to contain CR/LF Access does not strip them or escape them in any way. The results in a CSV file with end of line markers in the middle of data fields.
IIRC, Access always wraps double quotes around text/memo fields, or at least can be told to do so. If so, a CR/LF will give you a line with an odd number of double quotes. A little awk/perl/sed script could look for odd lines and paste the next line onto it...