Need Help Appending Records without duplicating records

[oblivion86]

Hi guys,

I have 2 databases which are exactly the same in its structure but differs in its content/records.

I would like to append data from 3 tables from database A to the same 3 tables in database B on a weekly basis without the duplicates.

Each of these 3 tables contain the same unique identifier (i.e. Employee ID)

Table1 (Personal Particulars): Employee ID, Employee Address, Contact Number.

Table2 (Employee Equipments): Employee ID, Equipment.

Table3 (Employee Qualifications): Employee ID, Qualifications.

How do I go about appending the records without duplicating records everytime i append the records when I back the data up?

Thanks!!

 

[llkhoutx]

Immediately prior to appending check the table for data identical to that being appended.