Import XML from web through code

J

Jared

Hi can you please advise how I can pull xml data from a website through code
on a regular basis.

My goal is to update the data monthly, with no interaction by the user.

I have tried:

Access.Application.ImportXML "http:\\www.........xml" , acStructureAndData

But get the error:
Micrsoft Access has encountered an error processing the xml schema in the
file xxxx"

"Quote expected"


Thanks
 

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

Import XML - Runtime Error 31592 3
Import error "The specification XML failed to validate " 4
A Look Into The Good and Bad Points of XML 0
import xml not a problem, setting key for subtables is 1
Import XML problem. 3
Help Creating XML File from Spreadsheet 1
Cannot Import XML Spreadsheet 2003 with XML Data Source 0
Access refuses to import date format from xml file... stumped 0

Top