Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to link a table in Access 2010 to an XML file and no matter what I do I get this error: "Only XML files can be imported from an Internet address (http://, ftp://). Enter a path that points to a location on your computer or on the network.".

At first I was going to generate the XML on the fly but when the import didn't work I just uploaded a plain XML file (that I exported from Access!) and that didn't work either. Any ideas?

share|improve this question
    
It would be really nice if Access supported a linked to able to a URI. It certainly knows how to parse, and also it knows how to read a file off the wire (because XML files can be imported via http). But, linking is blocked. – Paul Keister Oct 6 '11 at 0:21
    
@PaulKeister Maybe that should be an answer! – tooshel Oct 18 '11 at 21:23

HTML and XML import options in Access 2010 are remarkably limited. Here's the gist of it:

  • XML: can be read from the local network or via HTTP, but cannot be used to create a linked table.
  • HTML: can be used to create a linked table or imported, but can only be read from the local network or file system.

It's very tempting to editorialize about how disappointing this is; in any case those are the facts.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .