This documentation is archived and is not being maintained.

Application.ImportXML Method

Office 2007
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.
ImportOptionsOptionalAcImportXMLOptionA 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.

Visual Basic for Applications
Application.ImportXML _
    DataSource:="employees.xml", _
    ImportOptions:=acStructureAndData

See Also


Show: