Question about ImportXML Method

[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

 

[Van T. Dinh]

(previously answered in modulesdaovba).

Please do not multi-post. Please see:

http://www.mvps.org/access/netiquette.htm