Application.ExportXML (Access)
The ExportXML method allows developers to export XML data, schemas, and presentation information from Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), Microsoft SQL Server 6.5 or later, or the Microsoft Access database engine.
Although the DataTarget, SchemaTarget, and PresentationTarget arguments are all optional, at least one must be specified when you are using this method. When the ExportXML method is called from within an AccessObject object, the default behavior is to overwrite any existing files specified in any of the arguments.
ExportXML (ObjectType, DataSource, DataTarget, SchemaTarget, PresentationTarget, ImageTarget, Encoding, OtherFlags, WhereCondition, AdditionalData)
Sub ExportCustomerOrderData()
Dim objOrderInfo As AdditionalData
Dim objOrderDetailsInfo As AdditionalData
Set objOrderInfo = Application.CreateAdditionalData
' Add the Orders and Order Details tables to the data to be exported.
Set objOrderDetailsInfo = objOrderInfo.Add("Orders")
objOrderDetailsInfo.Add "Order Details"
' Export the contents of the Customers table. The Orders and Order
' Details tables will be included in the XML file.
Application.ExportXML ObjectType:=acExportTable, DataSource:="Customers", _
DataTarget:="Customer Orders.xml", _
AdditionalData:=objOrderInfo
End Sub
Arguments
The following arguments are required:
ObjectType (AcExportXMLObjectType) - An AcExportXMLObjectType that represents the type of AccessObject object to export.
Possible values are
| acExportForm | Form |
| acExportFunction | User-defined function (Microsoft Access project only) |
| acExportQuery | Query |
| acExportReport | Report |
| acExportServerView | Server view (Microsoft Access project only) |
| acExportStoredProcedure | Stored procedure (Microsoft Access project only) |
| acExportTable | Table |
DataSource (String) - The name of the AccessObject object to export. The default is the currently open object of the type specified by the ObjectType argument.
Optional arguments
The following arguments are optional
DataTarget (String) - The file name and path for the exported data. If this argument is omitted, data is not exported.
SchemaTarget (String) - The file name and path for the exported schema information. If this argument is omitted, schema information is not exported to a separate XML file.
PresentationTarget (String) - The file name and path for the exported presentation information. If this argument is omitted, presentation information is not exported.
ImageTarget (String) - The path for exported images. If this argument is omitted, images are not exported.
Encoding (AcExportXMLEncoding) - An AcExportXMLEncoding constant that specifies the text encoding to use for the exported XML. The default value is acUTF8.
Possible return values are acUTF16 - UTF16 encoding, acUTF8 - UTF8 encoding.
OtherFlags (AcExportXMLOtherFlags) - A bit mask that specifies other behaviors associated with exporting to XML. Can be a combination of AcExportXMLOtherFlags constants.
Possible values are
| acEmbedSchema | Writes schema information into the document specified by the DataTarget argument; this value takes precedence over the SchemaTarget argument. |
| acExcludePrimaryKeyAndIndexes | Does not export primary key and index schema properties. |
| acExportAllTableAndFieldProperties | The exported schema contains properties of the table and its fields. |
| acLiveReportSource | Creates a live link to a remote Microsoft SQL Server 2000 database. Valid only when you are exporting reports that are bound to a Microsoft SQL Server 2000 database. |
| acPersistReportML | Persists the exported object's ReportML information. |
| acRunFromServer | Creates an Active Server Pages (ASP) wrapper; otherwise, default is an HTML wrapper. Applies only when you are exporting reports. |
WhereCondition (String) - Specifies a subset of records to be exported.
AdditionalData (AdditionalData) - Specifies additional tables to export. This argument is ignored if the OtherFlags argument is set to acLiveReportSource.