Importing xml file to excel

[fiefie.niles]

When I import an xml file to excel 2003 or 2007, they both asked the
following questions:
1. the specified xml source does not refer to a schema. Excel will
create a schema based on the xml source data. I click OK
2. where do you want to put the data ? I select the default, which is
"XML list in existing worksheet R1C1" and click ok.

And the xml file is imported to excel 2003 and 2007 fine.
For example:
the following is in the xml file:
<XML Index="1">
<Ticket>111</Ticket>
<Name>Doe, Joe</Name>
</xml>
<XML Index="2">
<Ticket>222</Ticket>
<Name>Smith, Jane</Name>
</xml>
After importing it to the excel 2003 or 2007, with columns "Index",
"Ticket" and "Name" and 2 rows of data.

But, when I tried to import the xml file to excel 2002, it puts all
the info in 1 column and the data looks still has the words
<Ticket>111</Ticket>, <Name>Doe, Joe</Name>, etc.
In excel 2002, when importing, it did not prompt me about the schema
(in 2003 and 2007 it prompts me with "the specified xml source does
not refer to a schema. Excel will create a schema based on the xml
source data.).
How can I import the xml file into excel 2002 ?

Thank you.

 

[Jim Rech]

You might make sure you have the latest patches. When I imported the file
into Excel 2002 SP3 it did behave differently than Excel 2003 and 2007 (no
prompts) but the data did come in on one line.

--
Jim
| When I import an xml file to excel 2003 or 2007, they both asked the
| following questions:
| 1. the specified xml source does not refer to a schema. Excel will
| create a schema based on the xml source data. I click OK
| 2. where do you want to put the data ? I select the default, which is
| "XML list in existing worksheet R1C1" and click ok.
|
| And the xml file is imported to excel 2003 and 2007 fine.
| For example:
| the following is in the xml file:
| <XML Index="1">
| <Ticket>111</Ticket>
| <Name>Doe, Joe</Name>
| </xml>
| <XML Index="2">
| <Ticket>222</Ticket>
| <Name>Smith, Jane</Name>
| </xml>
| After importing it to the excel 2003 or 2007, with columns "Index",
| "Ticket" and "Name" and 2 rows of data.
|
| But, when I tried to import the xml file to excel 2002, it puts all
| the info in 1 column and the data looks still has the words
| <Ticket>111</Ticket>, <Name>Doe, Joe</Name>, etc.
| In excel 2002, when importing, it did not prompt me about the schema
| (in 2003 and 2007 it prompts me with "the specified xml source does
| not refer to a schema. Excel will create a schema based on the xml
| source data.).
| How can I import the xml file into excel 2002 ?
|
| Thank you.

 

[fniles]

Thank you.

but the data did come in on one line.

So, it's not working in excel 2002 even on sp3 (because the data are all in
1 line instead of creating columns for each element) ?