Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 data import wizard does not support line ends in fields
If data is stored in a .csv in a format as below the import wizard adds the
'next line' text on the next row, whereas opening the .csv directly maintains it in the correctly in thecsame cekk as 'one line' one,two "this,that","one line next line" The reason why we need to use data import wizard rather than simply opening directly in Excel is that in production case our data in UTF-8 unicode which can only be specified manually using data import wizard. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I import the pivot table wizard into Excel (2003)? | Excel Discussion (Misc queries) | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
How do I use template wizard with data tracking in Excel 2003? | Excel Discussion (Misc queries) | |||
excel import external data wizard | Excel Discussion (Misc queries) | |||
Where is the Template Wizard with Data Tracking Excel 2003? | Excel Discussion (Misc queries) |