XML newbie question

[projecttoday]

I am a newbie with XML to Access. I am trying to import some data from a website into my database by simply copying a line of code from another database. Here is the code:

Application.ImportXML DataSource:=[URL]http://website/Engineering/Tech%20Ops/RepeatTC.xml[/URL]

(I have changed the name of the website.) This statement runs in the other database and takes 10 seconds or so. In my database it just hangs.

Neither database has a table named RepeatTC, (at least not that I can tell.) The website in the code does exists.

As I indicated, I am a newbie with XML so what's the first thing I should do or check?

 

[Galaxiom]

Check whether the XML is Element Centric or Attribute Centric. Access only supports Element Centric XML.