Re: Excel importing of csv and xml

From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 08:33:51 -0600

Well, I supposed some might consider those "smart" features - i.e., not
turning numbers into Text, just because they have a leading zero, but...

You can certainly automate the process - start by recording a macro
(Tools/Macro/Record new macro...).

As for XML, XL imports according to the MS Spread*** schema. If you
want to import numbers in a different format, the generating application
should generate the file IAW that schema.

Alternatively, you could easily use another app to perform a transform.
I use Applescripts to do this with my Mac clients.

In article <#g6A0JKdEHA.3016@tk2msftngp13.phx.gbl>,
 "Bernie Yaeger" <berniey@cherwellinc.com> wrote:

> OK, I see that Excel in various versions (2000, xp) is stupid when it
> imports .csv and .xml in certain ways. Specifically, a string of '01503'
> comes in as numeric data of 1503 in both formats, notwithstanding that in
> both files they appear as '01503'. However, if the csv file has a .txt
> extension, it will first require that you specify certain import
> instructions, such as delimiter, data type, etc, and then it will import it
> correctly!
>
> Here's my question: how can I automate this process, so that it can be
> imported correctly without having to 'trick' Excel (and, by the way, an xml
> version does not give me any 'trick the system' opportunity).