Question about ImportXML Method

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to programatically (ie, via Access VBA) import an XML file into
either an Access 2003 table or a SQL Server 2000 table.

I see that there is an ImportXML Method, but in its syntax help reference, I
do not see where you would specify the specific receiving Access or SQL
Server table.

Here is the only example I found in the Access 2003 help:

-----------------------------------------------------------------------------

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

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

-----------------------------------------------------------------------------

So, my question is, how/where do you specify to the ImportXML Method which
particular Access or SQL Server table to receive the imported XML data?

- Charlie CT
 
Back
Top