How to import XML data from webservices using VBA?

Y

Yolande

Hi there,

I try to import/update the XML data from webservices when I click a button
in the SwitchBoard form. It seems that I need use DoCmd.TransferText
acImportDelim to import the data but I don't know where to specify the web
request string. Also, the XML file I imported creates several tables. When I
import it twice, it creates second set of tables. How can I avoid it and let
the data go into the same tables created in the first time? Any help?

Thanks.

Yolande
 

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

Importing XML Data in Access 2003 1
Adding data to MS Access from csv file 0
Saving Import Errors 0
Import Specs Changed "Magically" in Midst of Loading Sequence 3
Import Excel CSV file into Access 2007 2
Show customUI when I launch the contextMenu from a VBA macro 0
Importing Project 2007 XML data into Access 2007 0
Problems Importing Govt. XML Files 1

Top