Excel table to Access table Merge/Sync

[fh2level]

I have searched but not found what I am looking for. If I have missed something please point me in the right direction.

I get an excel file every couple of weeks with updated information, some deletions, some additions, and some things remain the same. What I need to do then is copy that into my Access table. The problem is the lists are so long I can not go through them and pick out what has changed so I therefore have to copy the entire excel table and totally replace the Access table. Is there anyway I can write a macro that will merge the new information from the excel file to the access table? If so please give as much guidance as willingly possible, I am new at macros.
Thanks

 

[bvan]

Excel Problem

You can link to an Excel spreadsheet. Once the spreadsheet is linked, you can use it in a query just like a table. The only thing is that the name of the spreadsheet can not change. The link will only work if the full path and name of the spreadsheet are the same. You can overwrite the spreadsheet with one of the same name, and your link will still work.

 

[fh2level]

Ok...that would work...BUT...there are names that will be deleted on the New Excel sheet that are in the datbase and need to stay in the Database.

So Basicly I need and Export from Excel to Access that: 1. Checks for duplicates 2. Adds the new names to the Access table that are in the New Excel file but not in the Access table 3. Keep names that are in the Access table but not in the New Excel table.