Nov 03 2020 10:17 AM
Does excel has a way to explore and access tables in a "file.db"
Nov 03 2020 11:05 AM
I'm not an access expert, knows less than a penguin where the Bahamas is.
But I have Microsoft's database where I can find information and send it to you if you haven't seen it yet ... and maybe it will help you a bit.
xBaseView Database Explorer - is a free trial
https://database-viewer-editor.soft112.com/
ExportWithFormatting macro action
Hope I could help you at least a little.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
Nov 03 2020 12:33 PM
Power Query shall work with Access database, but I have no practical experience. Lot a post about that, e.g. https://www.dummies.com/software/microsoft-office/excel/how-to-query-an-access-database-tables-from-...