Jun 30 2020 04:03 PM
Jul 01 2020 12:48 PM
You may try Power Query using the connector to Access database.
Jul 01 2020 09:07 PM
Jul 02 2020 01:54 PM
You may check https://www.dummies.com/software/microsoft-office/excel/how-to-query-an-access-database-tables-from-... and I believe you may google for more.
As I understood you need to import into the data model, not into Excel sheet, thus you have chances. Data model on practice is limited only by memory size. Another story is performance, it depends.
And perhaps you don't need entire Access table, only part of it, if so you may apply filter / columns transformation in Power Query.