I have a table in excel that is updated daily - it's possible for old numbers to be revised, so it's important that the data is 'live' so I link to the excel spreadsheet rather than import the data.
I've now go to the point where I've exceeded the million rows that Excel allows, so want to extend onto another sheet or spreadsheet file.
Is there a way to link 2 excel table to one access database table?
If there's a way, that would be amazing!
Thank you in advance for any help you may have.
/edit I'm now using Windows 10 and Access 2013