Importing xml

[Ian Belcher]

Hi, I'm tring to import an xml file into Access 2003.
Within the file are several related tables, but when I
import the file, none of the tables are related.
E.g.
<Person>
<Name>Ian</Name>
<ShoppingItem>
<ItemName>Apple</ItemName>
</ShoppingItem>
</Person>
<Person>
<Name>Bob</Name>
<ShoppingItem>
<ItemName>Orange</ItemName>
</ShoppingItem>
<ShoppingItem>
<ItemName>Banana</ItemName>
</ShoppingItem>
</Person>

Provides me with two tables, Person and ShoppingItem.
Both tables are just a list of the elements (i.e. Person
has 1 field called Name with two rows, Ian and Bob.
ShoppingItem has 1 field called ItemName with three rows,
Apple, Orange and Banana)
Is there a way to import a file so I know that Ian bought
an apple and Bob bought an orange and a banana?

Thanks
Ian Belcher