When attempting to import a .csv file to Excel all of it gets dumped in cell A1
--
Hugh

Depends on the actual contents of the file.

If it's a genuine .csv ie comma seperated valus
it should work fine each time.

Steve


On Thu, 25 Jan 2007 16:48:56 -0000, HughP
wrote:

When attempting to import a .csv file to Excel all of it gets dumped in
cell A1

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