Excel 2000 importing csv

[Guest]

We have a couple of users still using Win2K/Office 2K. There is a web based
application that exports data into Excel in a csv format. For these users,
all of the data gets dumped into Column A rather than separating. For users
on WinXP/Office 2003, we have gone into the Regional options and made sure
the List Separator option is set to comma. We tried this on the Win2K machine
but it did not resolve the problem. The users could go through the Text to
Columns wizard to separate, but this is something they will be doing daily
and it should separate automatically.

Any other ideas to try?
Thanks!

 

[Pete_UK]

You could try right-clicking on one of the .csv files then Open With -
click Choose Program at the bottom of the list, then check on "Always
use selected program to open this kind of file", then highlight Excel
from the list (or choose Browse if it is not displayed), then OK.

Hope this helps.

Pete

 

[Guest]

Unfortunately that is not an option. The web application automatically opens
Excel and populates the data.

Thanks!

 

[Gord Dibben]

The general suggestion is to change the *.CSV extension to *.TXT which pops up
the Text Wizard.

If your application will not allow that then you may have to go the extra step
and do it manually after the data is in Excel.


Gord Dibben MS Excel MVP

 

[Guest]

Thanks. It looks like for the users with Excel 2000, we need to create a
macro to do the delimiting.