This documentation is archived and is not being maintained.

ImportXML Method [Access 2003 VBA Language Reference]

Office 2003

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 Jet database engine.

expression.ImportXML(DataSource, ImportOptions)

expression Required. An expression that returns an Application object.

DataSource  Required String. The name and path of the XML file to import.

AcImportXMLOption can be one of these AcImportXMLOption constants:
acAppendData
acStructureAndData default
acStructureOnly

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
		


Applies to | Application Object

See Also | ExportXML Method


Show: