creating xml file from access 2k db

[hotreca]

hi
I'm trying to export an access 2k db as a xml file in the format below using vba as I need to process the file and that does not work when I use the namespaces

<?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;filename.xsd&quot;>;
<parent>
<child1>bla</child1>
<child2>bla bla</child2>
<child3>bla bla bla</child3>
</parent>
<parent>
<child1>bla</child1>
<child2>bla bla</child2>
<child3>bla bla bla</child3>
</parent>
</dataroot>

or even better as
<?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?>
<root>
<parent>
<child1>bla</child1>
<child2>blabla</child2>
<child3>blablabla</child3>
</parent>
<parent>
<child1>bla</child1>
<child2>blabla</child2>
<child3>blablabla</child3>
</parent>
</root>


any help would be apreciated