Importing Files

[scgoodman]

New to access, so please bare with me. I have a table that is the host for all my master data. I have a field in the table that does not except duplicates. It is the HouseAirwayBill. Every day I get a file from another source and I import it into my database, however since my HouseAirwayBill does not except dups...it does not import those records. I need them to import and overwrite the record that exists. How do I accomplish this?
Please help.

 

[georgedwilkinson]

You always import data into a staging table with no rules and then insert/update into your live tables as required.