View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
what delimiter do you use in the *.csv files and what delimiter is set in
your OS

"Nightwing" wrote:

I recently upgraded from Excel 2000 to Excel 2003. Since then
I cannot read *.csv files correctly. The columns are not being correctly
shown all, the data is stuck on the same cell. That is to say all the data is
on the first column on each row.

If I rename the file as a *.txt and then load it then I get the import text
wizard and I can set the delimiter. But I cannot be doing that on all my
*.csv file there are thousands of them.

This happsns on all *.csv files.

Thanks in Advance
Matthew