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.