Excel 2002 and XML

[scantor145]

Excel issues

--------------------------------------------------------------------------------

I have an XML file. Here are my 2 problems:

When I open the file in Excel 2002, Excel duplicates every column tha
has only integers in it, adding a #agg to the duplicate column title.
don't want the columns duplicated (obviously).

The second issue is that it is alphebetizing my columns. I don't wan
them alphebetized. I want them in the order in which they are listed.

Here is my XML code. You could simply cut and paste this into a blan
text document and save it as a .xls file. Then it will open in Exce
and you will see what I mean.


Code
-------------------
<?xml version='1.0'?>
<NewDataSet>

<Table>

<Condition>Consignment</Condition>
<Type>Deck Boats</Type>
<Make>Tracker</Make>
<Year>1999</Year>
<Model>AMP-456</Model>
<Engine>Honda</Engine>
<HP>75</HP>
<Price>4.00</Price>
<Stock>65423467</Stock>

</Table><Table>

<Condition>New</Condition>
<Type>Bass Boats</Type>
<Make>Baja</Make>
<Year>1990</Year>
<Model>ABC1990</Model>
<Engine>Chrysler</Engine>
<HP>120</HP>
<Price>76547.00</Price>
<Stock>6543-DFHG</Stock>

</Table><Table>

<Condition>New</Condition>
<Type>Bass Boats</Type>
<Make>Baja</Make>
<Year>1999</Year>
<Model>GHKJJ-MX</Model>
<Engine>Chrysler</Engine>
<HP>100</HP>
<Price>2534.00</Price>
<Stock>543243</Stock>

</Table>

</NewDataSet>
-------------------




Thanks for any help you can give me in advance