Importing XML

  • Thread starter Thread starter Ian Belcher
  • Start date Start date
I

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
 
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).
 
Back
Top