Append non-duplicates in a query

[SQLWilts]

Hi,
I feel a little lazy asking you guys here about something this simple, but.....
I have to write a query that pulls data from a table on a remote database into an existing table in the local one.

Simple enough, with an append query, but how do I ensure that no duplicates are imported (ie new data only)?

The table is DT Master, keyed on:
SISKEY (date with shift 1-3 appended)
Coiling Unit (Text file containing Pasaban1, Pasaban2, Sulzer and Gorostidi)

TIA

Tony

 

[grnzbra]

you could create an "Unmatched" query and then use that to drive the append query.

 

[SQLWilts]

Sorry, but sussed it.

I call the append query in code, turning warnings off before I run it, and turning them back on afterwards. Because the table has a unique key, it will only append unique records - or in other words, only the new records.