United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Office and SharePoint development

Office client development

Office 2010

Access 2010

Access 2010 Developer Reference

Access Object Model Reference

Application Object

Methods

Application.AccessError Method (Access)

Application.AddToFavorites Method (Access)

Application.BuildCriteria Method (Access)

Application.CloseCurrentDatabase Method (Access)

Application.CodeDb Method (Access)

Application.ColumnHistory Method (Access)

Application.CompactRepair Method (Access)

Application.ConvertAccessProject Method (Access)

Application.CreateAccessProject Method (Access)

Application.CreateAdditionalData Method (Access)

Application.CreateControl Method (Access)

Application.CreateForm Method (Access)

Application.CreateGroupLevel Method (Access)

Application.CreateReport Method (Access)

Application.CreateReportControl Method (Access)

Application.CurrentDb Method (Access)

Application.CurrentUser Method (Access)

Application.CurrentWebUser Method (Access)

Application.CurrentWebUserGroups Method (Access)

Application.DAvg Function (Access)

Application.DCount Method (Access)

Application.DDEExecute Method (Access)

Application.DDEInitiate Method (Access)

Application.DDEPoke Method (Access)

Application.DDERequest Method (Access)

Application.DDETerminate Method (Access)

Application.DDETerminateAll Method (Access)

Application.DefaultWorkspaceClone Method (Access)

Application.DeleteControl Method (Access)

Application.DeleteReportControl Method (Access)

Application.DFirst Method (Access)

Application.DirtyObject Method (Access)

Application.DLast Method (Access)

Application.DLookup Method (Access)

Application.DMax Method (Access)

Application.DMin Method (Access)

Application.DStDev Method (Access)

Application.DStDevP Method (Access)

Application.DSum Method (Access)

Application.DVar Method (Access)

Application.DVarP Method (Access)

Application.Echo Method (Access)

Application.EuroConvert Method (Access)

Application.Eval Method (Access)

Application.ExportNavigationPane Method (Access)

Application.ExportXML Method (Access)

Application.FollowHyperlink Method (Access)

Application.GetHiddenAttribute Method (Access)

Application.GetOption Method (Access)

Application.GUIDFromString Method (Access)

Application.HtmlEncode Method (Access)

Application.hWndAccessApp Method (Access)

Application.HyperlinkPart Method (Access)

Application.ImportNavigationPane Method (Access)

Application.ImportXML Method (Access)

Application.InstantiateTemplate Method (Access)

Application.IsCurrentWebUserInGroup Method (Access)

Application.LoadCustomUI Method (Access)

Application.LoadFromAXL Method (Access)

Application.LoadPicture Method (Access)

Application.NewAccessProject Method (Access)

Application.NewCurrentDatabase Method (Access)

Application.Nz Method (Access)

Application.OpenAccessProject Method (Access)

Application.OpenCurrentDatabase Method (Access)

Application.PlainText Method (Access)

Application.Quit Method (Access)

Application.RefreshDatabaseWindow Method (Access)

Application.RefreshTitleBar Method (Access)

Application.Run Method (Access)

Application.RunCommand Method (Access)

Application.SaveAsAXL Method (Access)

Application.SaveAsTemplate Method (Access)

Application.SetDefaultWorkgroupFile Method (Access)

Application.SetHiddenAttribute Method (Access)

Application.SetOption Method (Access)

Application.StringFromGUID Method (Access)

Application.SysCmd Method (Access)

Application.TransformXML Method (Access)

Minimize

This topic has not yet been rated - Rate this topic

Application.ImportXML Method (Access)

Office 2010

Office 2013

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.

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

The following example imports an XML file into a new table named Employees in the current database.

Application.ImportXML _ 
 DataSource:="employees.xml", _ 
 ImportOptions:=acStructureAndData

Concepts

Application Object

Application Object Members

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.