When to import data from Excel into Access, rather than link Access to Excel spreadsheet?
Posted on 2012-12-21
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?