Each record or each field???
Maybe you could use a macro that writes your data:
J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html
Look for:
CSV with quotation marks around each field
Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly:
http://www.smokeylake.com/excel/text_write_program.htm)
Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm
Roger Kenner wrote:
How can I save from Excel into a comma-delimited format where each record is
enclosed in quotes?
--
Dave Peterson