Newbie here: Different XML format?

[flaviooooo]

Hi,

I'm trying to fill a Dreamweaver Template with data from an Access(XP)-database. I've exported the accesstable of my choice as an XML file. I tried importing it in the template, no such luck. Now I've created a dummy XML file, by exporting the editable regions as XML. I see that the two XMLfiles have totally different formats:

From Access:

<?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?>
<dataroot xmlnsd=&quot;urn:schemas-microsoft-comfficedata&quot; xmlns:xsi=&quot;

http://www.w3.org/2000/10/XMLSchema-instance&quot;

xsi:noNamespaceSchemaLocation=&quot;spelers.xsd&quot;>
<spelers>
<number>1</number>
<name>Abbruzzese</name>
</spelers>

From the template:

<?xml version=&quot;1.0&quot;?>
<leegbio template=&quot;/Templates/leegbio.dwt&quot;>
<doctitle><![CDATA[
<TITLE>XMLtest</TITLE>
]]></doctitle>
<number><![CDATA[{1}]]></number>
<name><![CDATA[{Abbruzzese}]]></name>
</leegbio>


Is there a way to export the access XML in the format of the dreamweaver XML?
Or to import the format of the Access XML into the dreamweaver template?

there are about 100 records, with 20 fields each and it is updated every week; so changing it manually is not an option