View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
houghi houghi is offline
external usenet poster
 
Posts: 56
Default Converting text for csv

Where can I find information on how to correctly export a file to csv,
so I can import it in MySQL correctly?

I start with something like "Chaussée". When I export this to csv, I get
"Chauss,e". What I would need is something like "Chaussée", because
when I import that, I do get "Chaussée" back on my site.

I could replace each "é" with "é", but that letter is not the only one
and there might be letters added later that are not there now.

Is there information on what to do exacly, or a script I could download
that does this for me?

--
houghi http://www.houghi.org
My experience with SuSE Linux 9.1

The businessworld is like prison and M$ made everybody their bitch.