Exporting several xml levels from excel

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.