Xml (1 Viewer)

rangersedge

Registered User.
Local time
Today, 13:47
Joined
Jun 13, 2014
Messages
82
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

Registered User.
Local time
Today, 13:47
Joined
Jun 13, 2014
Messages
82
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>
 

Users who are viewing this thread

Top Bottom