Access database "file.db" with excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1850391%22%20slang%3D%22en-US%22%3EAccess%20database%20%22file.db%22%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1850391%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20excel%20has%20a%20way%20to%20explore%20and%20access%20tables%20in%20a%20%22file.db%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1850391%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1850585%22%20slang%3D%22de-DE%22%3ESubject%3A%20Access%20database%20%22file.db%22%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1850585%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F438859%22%20target%3D%22_blank%22%3E%40Ocasio27%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EI'm%20not%20an%20access%20expert%2C%20knows%20less%20than%20a%20penguin%20where%20the%20Bahamas%20is.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EBut%20I%20have%20Microsoft's%20database%20where%20I%20can%20find%20information%20and%20send%20it%20to%20you%20if%20you%20haven't%20seen%20it%20yet%20...%20and%20maybe%20it%20will%20help%20you%20a%20bit.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ExBaseView%20Database%20Explorer%3C%2FSPAN%3E%20-%20is%20a%20free%20trial%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3E%3CA%20href%3D%22https%3A%2F%2Fdatabase-viewer-editor.soft112.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdatabase-viewer-editor.soft112.com%2F%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExportWithFormatting%20macro%20action%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fclient-developer%2Faccess%2Fdesktop-database-reference%2Fexportwithformatting-macro-action%3Fredirectedfrom%3DMSDN%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fclient-developer%2Faccess%2Fdesktop-database-reference%2Fexportwithformatting-macro-action%3Fredirectedfrom%3DMSDN%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20could%20help%20you%20at%20least%20a%20little.%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20patience%20and%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

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

2 Replies
Highlighted

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

 

Highlighted

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