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.

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

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

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