0 out of 1 rated this helpful - Rate this topic

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

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.

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