Append if record doesn't exist

[Lorlai]

I am trying to create an append query if the record does not exist in the table. I have two table, Product_Details and a temp table. They contain basically the same information, with the exception of the temp table having minor updates. I am trying to see if there is a new record in the temp table, and if so, then append it to the Product_details.



Product_Details:

ID Name Qty Color Zip
12 Hammer 2 red 80976
13 nail 900 silver 76532

Temp:

ID Name Qty Color Zip
12 Hammer 2 Black 80976
13 nail 900 silver 76532
14 Glue 6 blue 23412

My current statement is through the access UI query:
Field: Name
Table: Temp
Sort:
Append To: Product_Details.Name
Criteria: [Temp].[ID] Not Like [Product_Details].[ID]
or:

This yields nothing. Any idea what I can do so that it will add the records that are not present in Product_Details?

Thank you!

[June7]

You need to do something like:
INSERT into Product_Details SELECT FROM Temp WHERE NOT Product_Details.ID HAVING Temp.ID;

Just not sure of the syntax. Check this http://bytes.com/topic/sql-server/an...sert-procedure
or this http://www.eggheadcafe.com/microsoft...not-exist.aspx