topic Re: Access multiple .mdb files using Python in Data Engineering

Access multiple .mdb files using Python

Dhara — Tue, 14 Jun 2022 05:40:39 GMT

Hi,

I wanted to access multiple .mdb access files which are stored in the Azure Data Lake Storage(ADLS) or on Databricks File System using Python.

Can anyone help me on how can I do it? It would be great if you can share some code snippets for the same.

Re: Access multiple .mdb files using Python

User16764241763 — Sun, 17 Jul 2022 11:17:12 GMT

@Dhara Mandal Can you please elaborate a bit on the use case and what you have already tried on Databricks?

Re: Access multiple .mdb files using Python

Holland69 — Sat, 23 Jul 2022 06:14:24 GMT

You can open up one of the MDBs, and import tables into it from all the other MDBs. If there are really a lot of MDBs and it would be impractical to do it by hand, you can write some VBA code to open each MDB in turn and copy over the tables into your destination MDB.

Re: Access multiple .mdb files using Python

Anonymous — Tue, 23 Aug 2022 16:04:53 GMT

Hey there @Dhara Mandal

Hope everything is going great.

Just wanted to check in to see if you were able to resolve your issue and would you be happy to mark an answer as best or do you need more help? We'd love to hear from you.

Thanks!