Excel 2003 data import wizard does not support line ends in fields

C

ChrisLime

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.
 

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

Similar Threads

import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
CSV->Excel Data Problem 1
Import Data, using a command line switch 4
Forcing Excel to Import .CSV data 2
line break does not appear in CSV 3
Extract data in rows (with line breaks) to form a table 0
how do i convert text files into CSV files? 1
import external data as a List (not table) into excel 2010 with excel 2000-2003 list format 0

Top