ImportXML Method

Microsoft Access Visual Basic

expression    Required. An expression that returns an Application object.

DataSource   Required String. The name and path of the XML file to import.

ImportOptions   Optional AcImportXMLOption. The option to use when importing XML files.

AcImportXMLOption can be one of these AcImportXMLOption constants:
acAppendData
acStructureAndData default
acStructureOnly

Example

The following example imports an XML file into a new table named Employees in the current database.

Application.ImportXML _
    DataSource:="employees.xml", _
    ImportOptions:=acStructureAndData