Import .csv files to Excel
Does that mean each record in the .csv file goes into column A (A1, A2, ...,
A#)?
Or does this mean that all your data really go into A1?
If the data goes into separate rows in column A, verify that the list separator
that you specify in the control panel
Regional settings And language options|Regional options tab
customize button|Numbers tab
matches the delimiter used in the .csv file (use notepad to verify)
===
If all the data really goes into A1, then maybe there's a problem with the end
of line marker and the list separator???
HughP wrote:
When attempting to import a .csv file to Excel all of it gets dumped in cell A1
--
Hugh
--
Dave Peterson
|