When to import data from Excel into Access, rather than link Access to Excel spreadsheet?
Hello - I am taking over an Access 2010 app that links to an Excel 2010 spreadsheet that is currently at 52,000 rows.
I have a gut feeling that it would better to just import this data into the back end accdb (it's the typical split db implementation), but I'd like to have something to hang my hat on if/when questioned.
Has anybody seen any white paper-type articles about when it makes sense to import, rather than link?
8/22/2022 - Mon
Your help has saved me hundreds of hours of internet surfing.