View Single Post
  #1   Report Post  
Nightwing
 
Posts: n/a
Default *.csv file wont load correctly

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