Question Import only new records

[gspot]

Hello
I need to import an Excel file into an existing table of my Access DB. The problem is:
I only won’t to add the new records, if the value in the column “cod_req” (exccell) not exist in “cod_req” of the DB (Access), if so the record should be skipped.

Any ideas?

Thanks

 

[boblarson]

Import everything into a temporary table and then use an append query to append what you want to the actual table where you want the data.

 

[gspot]

Import everything into a temporary table and then use an append query to append what you want to the actual table where you want the data.

1 - I don’t know why in the append window in the Drop down list doesn’t appear the table that I wont (the table exists)!

2 – What should be the criteria, for the example that I give above?

Thanks for the Help

 

[boblarson]

1 - I don’t know why in the append window in the Drop down list doesn’t appear the table that I wont (the table exists)!

2 – What should be the criteria, for the example that I give above?

Thanks for the Help

Not sure why your table doesn't appear in the list (I would have to see the db to figure that out). As for the criteria, if the records are not to be duplicated, you can just run the append query and, if the records are duplicates (as long as you have set a primary key in the table to be appended to) it will not append those records.

 

[gspot]

Not sure why your table doesn't appear in the list (I would have to see the db to figure that out). As for the criteria, if the records are not to be duplicated, you can just run the append query and, if the records are duplicates (as long as you have set a primary key in the table to be appended to) it will not append those records.

Example of db in attach.
- There are 2 tables I won’t the contents of table Temp put in table Principal, however append window in the Drop down list doesn’t appear the table Principal. I must be doing something wrong….

- I need to append records when the value in the column “cod_req” (Temp) doesn’t exist in “cod_req” of Principal. The other fields could have the same value or not… independent of the primary key (ID)

Thanks

 

[boblarson]

I get the dropdown: