Excel and Access

[r121a947]

I have a large (60K records) Excel spreadsheet for which I use Access to perform searches, etc.

How do I ensure that Access is always opening the most recent version of my spreadsheet?

Any and all help will be greatly appreciated. Thanks.

 

[AlanSidman]

Link your Excel Table to Access and it will always be updated automatically.

 

[r121a947]

Thank you. Very helpful.