exportXML

[nikiokos]

Hi, i want to export an xml file from an access query with a different format of the default.
The default access exportXML format is something like this

<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlnsd="urn:schemas-microsoft-comfficedata" generated="2008-08-20T22:36:49">
<dokimi>
</dokimi>
</dataroot>

I want to change the dataroot element to catalog and the second level element(dokimi) it should i has an other name like product.
something like this.

<?xml version="1.0" encoding="UTF-8"?>
<catalog xmlnsd="urn:schemas-microsoft-comfficedata" generated="2008-08-20T22:36:49">
<product>
</product>
</catalog>

Any ideas

Thanks

 

[pono1]

Not sure how to do this inside Access but XSLT could be used outside of Access to transform the format...

http://www.w3schools.com/xsl/

Regards,
Tim