Automatically Export to an Xml file

[rtaman]

Hi there,

We have an Access 2013 database containing 3 tables which we would like to export to 3 XML files automatically.

I have created Saved Exports but I am wondering if there is some way I can create a Macro / VB Code or a batch file that I can either run from within software or run on a scheduled task to automate the process.

To recap; I need to;



1) Export all data from 3 tables within an Access Database to an XML files
2) Overwrite any existing XML files (i,e not ask the user each time if they want to overwrite)
3) Automate the process

Thanks very much in advance.
Regards
Rita

[cyanidem]

Application.ExportXML is what you need.

[rtaman]

Application.ExportXML is what you need.

Thank you very much - I will try that.

[rtaman]

Hi there

I have created a Visual Basic module within my Access 2013 database which I would like to run as a Batch file from an Oracle program.
The following is the module and it correctly exports the data in my Access table to an XML file when I run it from within Access.

Sub ExportVatCodes

' Export the contents of the Tax_Code table to an XML file.

Application.ExportXML ObjectType:=acExportTable, DataSource:="TAX_CODE",
DataTarget:="C:\AccessXML\Vat_Codes.XML”

End Sub

I am unsure of the next step to creating a batch/VBS file.
Any help would be greatly appreciated.
Thanks in advance