converter .mdb/.accdb para .csv

dica do site: https://stackoverflow.com/questions/18370387/mdb-export-not-creating-csv-file

 

You first need to install mdb-tools (Ubuntu, Debian):

sudo apt install mdbtools

Then to list the tables do this:

mdb-tables database.mbd 

then with the desired table

mdb-export database.mdb table > table.csv

To export all the tables try this command:

mdb-tables -d ',' database.mdb | xargs -L1 -d',' -I{} bash -c 'mdb-export database.mdb "$1" >"$1".csv' -- {}

 

update: 31/10/2019
converter .accdb

fonte: https://askubuntu.com/questions/342925/opening-an-accdb-file-in-ubuntu

comando:

mdb-tables -d ',' database.accdb| xargs -L1 -d',' -I{} bash -c 'mdb-export database.accdb "$1" >"$1".csv' -- {}