Allow load data from / link to Excel Table
Display Excel Table names in the Wizard when loading/linking external Excel data, currently only specific name range or the spreadsheet is visible.
Tom Perks commented
I agree, I have large excel workbook, with many sheets each containing a defined table. I would love to be able to continue using excel for inputting the raw data, but then use Access to manipulate and report etc using that data. Unfortunately, Access cannot link to a defined table in excel, only named ranges.
Also, whilst you can created a named range on top of the defined table, if using Excel 2016/365, Access refuses to acknowledge said named range.