XML import does not pick up all data

[0212]

Hi! I tried to import an XML File to Access 2003 and got 4 tables. However, in one table, I did not get all data. The XML structure is as follows:

Policy Info (Table 1)
Record 1
Agency Info (Table 2)
Record 1
Location Info (Table 3)
Record 1
LOB Info (Table 4)
Record 1
Record 2
Record x
Location Infor (Table 3)
Record 2
LOB Info (Table 4)
Record 1
Record 2

Table 4 only picks up the last record for each location. Also, there is no link information in the XML. I want to use the data structure to export similar data to the same XML Format. Does anyone have any ideas? This is similar to another one I posted, but provides a little more information. Thanks for any help that you can give!