problem in converting .xls to .csv

  • Thread starter Thread starter kumaraswamy
  • Start date Start date
K

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top