Import data and append changes only

Question

Hi this must have been asked loads of times before but I cannot find an answer.

I have a linked Excel table in Access tblExcelClientImport, from this table I want to export the data changes only into my Access table tblClientData this would include any new records that were not present.

How do I go about this?  I can build Append and Update Queries but what does the criteria have to be to make this work?

Any help would be appreciated.

Answer 1

Do you have match primary keys? Does your Excel table have a LastUpdated column?

I think I would import the Excel table into a temporary table in Access that has the same primary key. You could then create an update query. You could also create an append query that LEFT or RIGHT joins the two tables so you get all the records from the imported table.

Answer 2

I have a linked Excel table in Access tblExcelClientImport, from this table I want to export the data changes only into my Access table tblClientData this would include any new records that were not present.

Just link it in  tblClientData as it can be linked in multiple Access databases.