View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mathias Körber Mathias Körber is offline
external usenet poster
 
Posts: 1
Default importing CSV files correctly?

I have an app which generates CSV files which include only text in
several columns, some of which can have embedded newlines.

I need to import these into EXCEL for editing and saving back into the
same format.

Generally, EXCEL handles this ok by just opening the CSV file. As long
as all fields are properly quoted, things work.

EXCEPT for when a field contains just the text "true" or "false".
EXCEL will change these values to ' TRUE ' and ´ FALSE '
(centered!) on import ! ARGH!

Using the text-import wizard and setting all columns to 'text'
(what a chore, to be done every time!) works in that respect, but
apparently breaks the import of multiline fields.

Is there any way to tell EXCEL to import a CSV file correctly??\

I am using Excel 2000 (9.0.6926 SP-3)