How do I automatically import XML into Access 2003?

C

CLM

I need to create a button on a form that will automatically run the Get
External Data command. The file that needs to be imported is XML. I need
the import to Append to an existing table.

Does anyone know if this is possible?
 
J

John Nurick

The VBA method corresponding to Get External Data ... XML is
Application.ImportXML
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Internal Data Integrity (Type 4) Details Needed 1
Turning off automatic calculation 0
Importing XML Data in Access 2003 1
XML into Access 2003 3
Import XML from web page URL 0
overwrite specific 'quick parts' - HELP! 1
Appending an existing table with imported Excel data 0
Impoting XML from web page URL 0

Top