Add records from one table to another

[jpaokx]

Hi,

I have a question about appending or adding simply records.
Everyday, I get a database which is cummulative and I have a combined database with 3-4 tables from different sources but they have duplicates (same id, but different on other fields). I keep a specific structure.

However, my problem and my question is: How can I simply add the records from the database to the other table without adding duplicates?
For example, the database that I have is 500 records and my combined (3-4 tables) is 1600 records. If tomorrow I get the database with 510 records, how can I simply add the 10 new records? I imagine that the append query will add 510 records and eventually I will ended up with 2110 records.

Sorry if I confused anyone in case I didn't describe it correctly.

Any thoughts?

 

[Cronk]

Use an outer join to link the From table to the importing table with the join on id. This will show null in the id of the Importing table and you can base an append query on the id being Is Null.

 

[jpaokx]

Use an outer join to link the From table to the importing table with the join on id. This will show null in the id of the Importing table and you can base an append query on the id being Is Null.

Sorry for the delay. Sorry, I don't understand. How am I suppose to follow that in a simple append query? What will be my criteria? Could you please give me further details?
I don't know how to use outer join.

Thanks

 

[Cronk]

Assuming there is a key field for your 510 records in the source table, of which 500 correspond to the unique ID in the destination table, you are looking to append records that have a null value in the destination table.

Create an append query and join the two ID fields. Then right click on the join line and select join properties and select all records in the source table and only those in the destination table. In the criteria for the destination table, set the ID field to Is Null and that will give you all records in the source table that are not in the destination table.

Incidentally, the normal/default join between tables is to include records where they exist in both tables AKA an Inner join. In your case, you have created an outer join.

 

[jpaokx]

Assuming there is a key field for your 510 records in the source table, of which 500 correspond to the unique ID in the destination table, you are looking to append records that have a null value in the destination table.

Create an append query and join the two ID fields. Then right click on the join line and select join properties and select all records in the source table and only those in the destination table. In the criteria for the destination table, set the ID field to Is Null and that will give you all records in the source table that are not in the destination table.

Incidentally, the normal/default join between tables is to include records where they exist in both tables AKA an Inner join. In your case, you have created an outer join.

Fantastic!!!!!!Your instructions are now very clear. It worked!!!!
Thank you so much!!! You saved me a lot of working time!