Open XML in excel problem

[dermot_o_loughlin]

Hi all,

I have a problem opening xml in excel. If there are 2 or more rows in
the xml document it opens up fine in excel and shows headers. If there
is only 1 row in the xml document the headers do not get shown. Here is
some example xml:

1 Row
=====

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table>
<PropertyOwner_Id>232</PropertyOwner_Id>
<Propertyowner_MaritalStatus>Not
Known</Propertyowner_MaritalStatus>
<Propertyowner_FolioNumbers />
</Table>
</NewDataSet>

2 Rows
======

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table>
<PropertyOwner_Id>317</PropertyOwner_Id>
<Propertyowner_MaritalStatus>Not
Known</Propertyowner_MaritalStatus>
<Propertyowner_FolioNumbers />
</Table>
<Table>
<PropertyOwner_Id>318</PropertyOwner_Id>
<Propertyowner_MaritalStatus>Not
Known</Propertyowner_MaritalStatus>
<Propertyowner_FolioNumbers />
</Table>
</NewDataSet>

Any Ideas,
Dermot.