View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
maryj maryj is offline
external usenet poster
 
Posts: 76
Default 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!