How to update my database to my watchlist?

[tjb001]

I use one Excel file to import to my access, and it includes 5000+ records. But I just want 100 of them. How to update my watchlist to become the newest one when uploading the new database?
Thank you.

 

[Trevor G]

Welcome to the forum you would need to explain how the Excel workbook is set out and how you identify the latest 100 records before you will be able to find a solution that meets your needs.

 

[arnelgp]

Create a Unique index on one of your field in access (the one you dont want to have duplicate).