Exporting several xml levels from excel

[Mr. Kirkeby]

Hello.

I must export data from excel to an xml file using a schema like this:


*************************************************

<?xml version="1.0" encoding="UTF-8"?>

<data senddate="23/01/2009">

<site code="12345" latitude="56.4517" longitude="11.5431" unitid="1234">

<requireddata catchdate="19/11/2008"
numberofspecies="0">

<datatests>

<datatest id="1"
numspecies="0"/>

<datatest id="2"
numspecies="0"/>

<datatest id="3"
numspecies="0"/>

</datatests>
</requireddata>
</site>
</data>

**************************************************

-but the problem is that Excel 2003 somehow cannot associate the level
<datatest id="2"
numspecies="0"/>
with the xml schema. Is there any way I can sort this out? I would like to
keep the dataid (1,2,3 etc) as fixed numbers so only the numspecies change
for every entry.