Comma Delimited, saving of records - CSV File
 

I have 300 records in excel, and when I save as a CSV file, it does not put "
" around TEXT fields. i.e. CSV File
Phone # customer name address 1
5556570987,John, Smith Attorney,124 Main Street
------------- Should Be ---------------
5556570987,"John, Smith Attorney","124 Main Street"

I need a Field Delimiter of " and a field seperator of ,

Comma Delimited, saving of records - CSV File
 

I did a Google with the terms: Excel CSV quotes
I looked at the first dozen or so but only the first seems useful to you
http://www.mvps.org/access/modules/mdl0046.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Paul Bytes" wrote in message
...
I have 300 records in excel, and when I save as a CSV file, it does not put
"
" around TEXT fields. i.e. CSV File
Phone # customer name address 1
5556570987,John, Smith Attorney,124 Main Street
------------- Should Be ---------------
5556570987,"John, Smith Attorney","124 Main Street"

I need a Field Delimiter of " and a field seperator of ,