Xml

[rangersedge]

I'm having a hard time finding the answer to this. I get XML's from a site and want to import the data to Access. If I use the native import then I get multiple tables and the data is a little jumbled. For instance: I get 1 table with track names and a different table for track numbers with no way to relate the to accurately. I would like to be able to parse out the XML and have it update my table as it goes so I have less "junk" in my DB. I just can't figure out how to call out the XML tag and tell it to copy that info to the correct field. Any ideas?

 

[rangersedge]

Basically I need to fix how it imports the XML. This is the XML. I need to combine the track list and the recording tables...

<track-list count="10" offset="0">
<track id="361863fe-8f24-33b7-8188-de56a99f81c1">
<position>1</position>
<number>1</number>
<length>224360</length>
<recording id="5b6a715b-8ea6-48af-82e2-63614d0646d7">
<title>Fly on the Wall</title>
<length>224360</length>
<artist-credit>
<name-credit>
<artist id="66c662b6-6e2f-4930-8610-912e24c63ed1">
<name>AC/DC</name>
<sort-name>AC/DC</sort-name>
</artist>
</name-credit>
</artist-credit>
</recording>
</track>