up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
55% accept rate
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
feedback

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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