Exporting an table to XML

H

Hennie

Good Day,

I need to export a table as an XML file. Access 2002 does not have to ability to transform the file with an XSL into the correct format and save it as the style version but rather save it as an XML-flat file. The help file refers to DataTransform within the expression but it does not recognize the instruction. (Application.ExportXML acExportTable)

I do notice I can reference one of several versions of Microsoft XML,Vx.0. How would I use the referenced program to transform a table in the styled version and not the flat file? I had a glance at the object browser but I do not know how to use the browser to my advantage.

The following is the required information to be exported.

Table: sample
Style format: sample.xsl
XML file: sample.xml

Thank for your time.

Hennie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top