Table of contents
TOC
Collapse the table of content
Expand the table of content

Application.ImportXML Method (Access)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

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

NameRequired/OptionalData TypeDescription
DataSourceRequiredStringThe name and path of the XML file to import.
ImportOptionsOptionalAcImportXMLOptionAn 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

See also

Concepts

Application Object

© 2018 Microsoft