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?