Importing XML

[Ian Belcher]

I'm trying to import an XML file into Access 2002. Whilst
I can import the data into various tables, there are no
links or linking fields between the tables.
e.g.
....
<Customer>
<Name>Ian</Name>
<Address>20 High Street</Address>
<Purchase>
<Item>Pen</Item>
</Purchase>
<Purchase>
<Item>Pencil<Item>
</Purchase>
</Customer>
....
The above extract will create two tables (Customer and
Purchase). "Customer" will contain two fields (Name - Ian
and Address - 20 High Street) and "Purchase" will contain
one field (Item - Pen and Pencil). However, when imported
there will be no way of knowing that "Ian" purchased a pen
and a pencil.

This is my first attempt at importing xml and I can't find
any help on the matter, so any ideas would be very
grateful.

Thank you

Ian

 

[Joe Fallon]

Bottom line is that XML importing does not build relationships.
Just tables and data.

But if you build the tables yourself and setup a relationship and THEN
import the same file the tables should be filled with data (and the
relationship is maintained).