Import XML data in Access

G

Giancarlo

Hello,

I need to import an XML file like:

<?xml version="1.0"?>
<AllLinks>
<MID ID="AUD00197">
<Category ID="TD" Type="3">
<Link ID="0">67</Link>
</Category>
....

to create a table with fields

MID ID; Category ID; Type; Link ID; Link Value

the first record would be, for example:

AUD00197; TD; 3; 0; 67

Using Access import procedure I get a table with just one field "Link" whose
first record has value "67"

How to?

Thank you

Giancarlo
 

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

Top