[RndTbl] CSV files

Glen Ditchfield gjditchfield at acm.org
Tue Jul 13 08:56:31 CDT 2004

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

More information about the Roundtable mailing list