INSERT only the line not found

[sal21]

Have a 2 table with 23 fileds. The field1 of table1 and table2 have a unique id.
I want to insert from table1 to table2 only the records not found base the filed1.
I effect i wanto match all unique id of table1 with unique id from the table2.
How to via vbcode and adojet????

[HansV]

Execute the following SQL string:

strSQL = "INSERT INTO Table2 SELECT * FROM Table1 WHERE Table1.ID Not In (SELECT Table2.ID FROM Table2)"

Substitute the correct names of Table1, Table2 and the ID field.

[sal21]

Execute the following SQL string:

strSQL = "INSERT INTO Table2 SELECT * FROM Table1 WHERE Table1.ID Not In (SELECT Table.ID FROM Table2)"

Substitute the correct names of Table1, Table2 and the ID field.

(SELECT Table.ID FROM Table2)"
Table is table2?

[HansV]

Yes, sorry.

[sal21]

Yes, sorry.

PROB....
In in the table tath recive the new records in ID have a value complete but in table for mathching i need to join 2 filed to make the unique ID

[HansV]

Please provide enough details for us to understand the problem. Thanks in advance.

[sal21]

Please provide enough details for us to understand the problem. Thanks in advance.

sorry for my bad enghlish!

In effect in table1 have ID="1234567890" instead in table2 have the matching is a from joint from filed1&filed2 similar filed1=12345 filed2=67890....

I hope understand now, sorry.

[HansV]

Try

strSQL = "INSERT INTO Table2 SELECT * FROM Table1 WHERE Table1.ID Not In (SELECT Table2.Field1 & Table2.Field2 FROM Table2)"

If the fields of Table1 and Table2 are not identical, you may have to specify them explicitly:

strSQL = "INSERT INTO Table2 (Field3, Field4, Field5, Field6) SELECT FieldA, FieldB, FieldC, FieldD FROM Table1 WHERE Table1.ID Not In (SELECT Table2.Field1 & Table2.Field2 FROM Table2)"

substituting the appropriate names.