Heirachial XML

  • Thread starter Garry Robinson - Access MVP
  • Start date
G

Garry Robinson - Access MVP

How do you load an xml file where there is a heirachy and the xml file
does not store the foreign key in the lower table (something that is
allowed in XML, just not in Access). In the following xml, their
should be a a projectid being loaded in the Participants table. All
that happens in access is that the person field is loaded and no
project code.



<?xml version="1.0" encoding="utf-8"?>

<project>
<id type="integer">1002471</id>
<announcement>This project site is ready for action.</
announcement>
<created-on type="date">2007-04-05</created-on>
<name>ABN01</name>
<status>active</status>
<participants>
<person type="integer">1264017</person>
<person type="integer">1372011</person>
<person type="integer">1453703</person>
</participants>
</project>
 
G

Garry Robinson - Access MVP

I ended up resolving this by using MSXML and programming the xml in
detail.
 

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

Importing Project 2007 XML data into Access 2007 0
Nested for-each with external xml file (document('other.xml')) Issue 3
Import XML And Retain Relationships? Any Workarounds To Do So? 0
Serialization and Xml mapping 2
export access 2003 table to xml native format 7
Exporting data to xml file 3
Linq and xml question 2
Import XML file to Access 2007 2

Top