Heirachial XML

[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>

 

[Garry Robinson - Access MVP]

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