Application.ImportXML (Access)

The ImportXML method allows developers to import XML data and/or schema information into Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), Microsoft SQL Server 7.0 or later, or the Microsoft Access database engine.

ImportXML (DataSource, ImportOptions)

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

Arguments

The following argument is required

DataSource (String) - The name and path of the XML file to import.

Optional arguments

The following argument is optional

ImportOptions (AcImportXMLOption) - An AcImportXMLOption constant that specifies the option to use when importing XML files. The default value is acStructureAndData.

Possible return values are acAppendData - Imports the data into an existing table, acStructureAndData - Imports the data into a new table based on the structure of the specified XML file, acStructureOnly - Creates a new table based on the structure of the specified XML file.