Re: Excel importing of csv and xml

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 Spreadsheet 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).

Relevant Pages

  • Re: Bridge documents....Red Hearts and Diamonds, Balck Clubs and S
    ... When you create the autotext entry, format the text in the colour that you ... Is there a way to automate ...Autocorrect.Entries....so it adds: ... is), then select it and from the Tools menu, select AutoCorrect Options ...
    (microsoft.public.word.vba.general)
  • Formatting Numbers
    ... I'm importing data from an access database into an Excel spreadsheet. ... a column that contains numeric and alpha numeric data. ... format the numeric data so that it is in number format (currently it imports ... format of the alphanumeric data manually as there are only two or three ...
    (microsoft.public.excel.worksheet.functions)
  • Re: MISSING ZERO IN IMPORTED EXCEL DATA 104.10 = 104.1 ????HOW CAN
    ... My VB App converts the numeric data into text because I need to ... >> When importing from Excel (or any other external file format, ... Wherever you want to show the two decimals (or ...
    (microsoft.public.access.externaldata)
  • RE: Formatting Numbers
    ... "Frank Kabel" wrote: ... >>a column that contains numeric and alpha numeric data. ... >>format the numeric data so that it is in number format ... >>happens until I edit an individual cell. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Concatenate numbers
    ... leading "0" when concatenating the numbers and what settings affect ... should be stored in numeric data types. ... Or using that format pattern with the column command: ... column digits format  0.999999999999999999 ...
    (comp.databases.oracle.misc)