Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

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:
© 2015 Microsoft