Access vba export to xml file

Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services. Privacy policy. The ExportXML method can be used to export the data and formatting contained in a table, along with any additional data that you specify. To specify the additional data to export, you must use the CreateAdditionalData method to create an AdditionalData object. Please rate your experience Yes No. Any additional feedback?

In this article. The name of the AccessObject object to export. The default is the currently open object of the type specified by the ObjectType argument. The file name and path for the exported data. If this argument is omitted, data is not exported. We will not be using this. The default value is acUTF8 , and that will be just fine for us. WhereCondition Specifies a subset of records to be exported.

For us this is where we can choose the specific customer that we want to export. AdditionalData Specifies additional tables or queries to export. Add "qryCustomerOrders". Item "qryCustomerOrders". Item "qryXMLOrder". You can add other nodes of related data, by inserting the. Add line in the correct location. Categories Business Microsoft Access Windows.

The file name and path for the exported XML data. Thanks again!! Show 2 more comments. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked 0.