Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
importing into Excell 2000 | Excel Discussion (Misc queries) | |||
Using Excel 2000 as Data source for Word 2000 document | Excel Discussion (Misc queries) | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
Excel Programs developed in Office 2000 on Windows 2000 | Excel Discussion (Misc queries) |