Access database "file.db" with excel

Iron Contributor

Does excel has a way to explore and access tables in a "file.db"

2 Replies

@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/exportwit...

 

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)

 

@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-...