I need to Append but not all records.
If there is a match between the Projects table and Import-CSM then DO NOT APPEND.
I have the below, but I am not sure of the language for a NOT LIKE criteria
Basically, Append if the criteria is NOT LIKE.
The ProjectNo and Activity code are text
obviously the below is wrong (it is in plain English)
[Projects].[ProjectNo] NOT LIKE
here is the APPEND SQL:
INSERT INTO Projects ( ProjectNo, [Project Name] )
SELECT [Import-CSM].[Activity Code], [Import-CSM].[Activity Description]
Please see the pic