Importing XML Data Into MS Access 2002

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Having an issue with importing XML data into MS Access
2002. The import process creates the tables with rows of
data. However, the rows of data are blank. Ideas anyone?
 
if you using VB, then in MSXML2 exist app.ImportXML(options, path)
options are: data and structure, data only, structure only.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_accessxml.asp

ImportXML Method
The ImportXML method imports XML data and/or schema information into Microsoft SQL Server 2000 Desktop Engine, Microsoft SQL Server 7.0 or later, or the Microsoft Jet Database Engine.

Syntax
expression.ImportXML(DataSource, ImportOptions)
expression
Required. An expression that returns an Application object.

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

ImportOptions
Optional AcImportXMLOption. The option to use when importing XML files.

AcImportXMLOption can be one of these AcImportXMLOption constants.
acAppendData Only the data is imported from the specified data source; the schema information is ignored. The data is appended to a table corresponding to the name of the XML file if such a table already exists. If no such table exists, the data is appended to a new table.
acStructureAndData default Both the data and the schema information are imported from the specified data source to a new table. The default name for the new table is the name of the XML file minus any file extension. If a table with the default name already exists, Access will generate a unique name for the new table.
acStructureOnly Only the schema information is imported from the specified data source to a new table; the data is ignored. The default name for the new table is the name of the XML file minus any file extension. If a table with the default name already exists, Access will generate a unique name for the new table.

Remarks
 
Back
Top