There are two forms: Customer Account and Additional Contacts. Customer Account has a subform for additional contacts. However, the additional contacts were added separately before the subform was built. I need to connect up the additional contacts with the appropriate customer account. I have exported the data for both in separate excel sheets.

Details

The parent Account for a contact can be found by matching the "Ship To numbers" field.