Import XML from web through code

  • Thread starter Thread starter Jared
  • Start date Start date
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
 
Back
Top