Skip to content

[Linux] Convert mdb database of Access to csv to load

Microsoft Office Access is a relational database management system developed by Microsoft with its own database format.

Although it is relatively rare now, it does not mean that there is no such thing.

I encountered such a problem a few days ago, I had a must see .mdb file (Access data format), and then my OpenOffice base could not be opened.

Fortunately, I found this handy tool: https://github.com/pavlov99/mdb-export-all


How to use

If you have no mdbtools tool, you can use the following command to install it:

sudo apt-get install mdbtools


And then, we can execute a shell script in the above GitHub project, its name is mdb-export-all.sh.

We just need to execute it and enter the .mdb file to be converted, and then we can get the converted file.

For example:

bash mdb-export-all.sh full-path-to-ms-access-db.accdb

Leave a Reply