Access multiple .mdb files using Python

[Dhara]

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.

[User16764241763]

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

[Holland69]

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.

[Anonymous]

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!