Excel 2000 importing csv
 

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!
--
maryj

Excel 2000 importing csv
 

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

On Jul 25, 1:54 pm, maryj wrote:
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!
--
maryj

Excel 2000 importing csv
 

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

Thanks!
--
maryj


"Pete_UK" wrote:

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

On Jul 25, 1:54 pm, maryj wrote:
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!
--
maryj

Excel 2000 importing csv
 

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

On Wed, 25 Jul 2007 07:24:02 -0700, maryj
wrote:

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

Thanks!

Excel 2000 importing csv
 

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


"Gord Dibben" wrote:

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

On Wed, 25 Jul 2007 07:24:02 -0700, maryj
wrote:

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

Thanks!