Access database "file.db" with excel

Ocasio27 

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-excel-2019/

Ocasio27 

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

https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/exportwithformatting-macro-action?redirectedfrom=MSDN

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)