Question Importing data in to multiple tables

[mountainview]

I have a customer database which has a main form/table for customer addresses etc. then a sub form/table for contacts within each company.

I have created and export excel file, which contains the main customer data, and individual contact names to allow me to create a mail shot list targeted against specific people within each company. All OK so far.....

I send this file to our office, who then mail shot our customers..... They then add to the excel sheet when the mail was sent, and which brochures were sent.

I'm trying to then import the date and brochure information back in to each of my contacts records, as I already have a "notes" field for each contact withing the database. It's how to import data that references multiple tables that I'm not getting?

Anyone point me in the right direction please

Thanks Paul

 

[CJ_London]

create a linked table to the file and use update or append queries

 

[mountainview]

Many thanks for the fast reply, I'll take a look at the linked tables and see what I can do...... I may be back

Thanks

Paul