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
 
Top