append query problem

[spec]

Hi,

I had a problem in appending data to table.
I had to append Table1 data to Table2, and the condition is that i should not append the records if they are already present in Table2.
How to do this?
Please help, i am in urgent need for this.

Thanks

 

[antomack]

You need to create an 'Unmatched' query to find all records in Table1 that are not in Table2 and append them to Table2, this is available from the wizard.

The query will look something like below
SELECT Table1.*
FROM Table1 LEFT JOIN Table2 ON Table1.Field1 = Table2.Field1
WHERE (((Table2.Field1) Is Null));

Field1 is a field in both tables that is common to both tables.