How can I import xml files into Microsoft Access 2000 ?

J

John Nurick

AFAIK there's no built-in capability; serious XML support only arrived
with Access 2003.

Besides upgrading, the alternatives are (a) use third-party tools to
parse the XML data into ordinary textfiles which Access can import or
(b) write Access VBA code to read the xml file, extract the data and put
it into your tables.

If you google for
convert XML to CSV
you'll find lots of stuff.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XML Source is Unavailable in Developer Tab 0
Internal Data Integrity (Type 4) Details Needed 1
Importing XML Data in Access 2003 1
XML into Access 2003 3
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
Importing XML 0
Problems Importing Govt. XML Files 1
Microsoft Project - error opening exported XML file 0

Top