problem in converting .xls to .csv

[kumaraswamy]

I am saving the excel file in csv format but it adding " to some of th
contents. I dont' know from where it is adding this. help me to save i
in csv format with out " (double quotes)

thanks
chandr

 

[Mr. Lee]

the double quotes around a field is used by excel to specify that "All the
content in here is in one cell"

if you have a comma inside a Cell, Excel needs to tell the csv file that
this is not a separation of fields, it's all inside one cell.
Like This:
Example: "--" shows different cells.
JOE-DOG-11 MAIN ST.--WASHINGTON DC--43101
JOHN--DOE--14 MAIN ST.--KIRKLAND,OH--07177
see how KIRKLAND,OH is in one cell.

since there is a comma in there, if the quotes weren't present, the next
time you opened the file in excel, it would look like this:
JOE-DOG--11 MAIN ST.--WASHINGTON DC.--43101
JOHN--DOE--14 MAIN ST.--KIRKLAND--OH--07177
now you would have one more column in just this recordset,
so all of your zipcodes would not be in the same row,