Application.ImportXML Method

  • Article
Access Developer Reference

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

See Also