Application.ImportXML method (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.


expression.ImportXML (DataSource, ImportOptions)

expression A variable that represents an Application object.


Name Required/Optional Data type Description
DataSource Required String The name and path of the XML file to import.
ImportOptions Optional AcImportXMLOption An AcImportXMLOption constant that specifies the option to use when importing XML files. The default value is acStructureAndData.

Return value



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

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.