Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

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

1 Answer

up vote 1 down vote

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.