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.
Syntax
expression .ImportXML(DataSource, ImportOptions)
expression A variable that represents an Application object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
DataSource |
Required |
String |
The name and path of the XML file to import. |
ImportOptions |
Optional |
AcImportXMLOption |
A AcImportXMLOption constant that specifies the option to use when importing XML files. The default value is acStructureAndData. |
Return Value
Nothing
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