COMPARE_TABLES_EXTRACT <>

[Guest]

Hi
I have a customer table1 in a access database with a Coloumn "Code" e.g
101931.
and on a monthly basis i get a update from outside source in excel sheet
Updated Customer table, with additional customers (code) added to the sheet.

I am converting the excel sheet into a new table2 which includes additional
" codes" along with old ones added during the month.

Now i require to compare two tables and extract only the one which is not in
Table1 .

In other words i need to list new customers (codes)

Thanks
ron

 

[Nikos Yannacopoulos]

Rony,

Try a query along the lines of:

SELECT * FROM Table2
WHERE Table2.Code Not In (SELECT Table1.Code FROM Table1)

Start making a new query in design view, add no table and go to SQL
view, where you can paste this SQL expression. Just make sure you have
the correct table and field names!

HTH,
Nikos

 

[Guest]

Thank you Nik
Rony

Rony,

Try a query along the lines of:

SELECT * FROM Table2
WHERE Table2.Code Not In (SELECT Table1.Code FROM Table1)

Start making a new query in design view, add no table and go to SQL
view, where you can paste this SQL expression. Just make sure you have
the correct table and field names!

HTH,
Nikos