How to converting Microsoft Access MDB into CSV or Mysql in linux



To get the list of tables, you run the following command:

mdb-tables database.mdb

You can then get a CSV version for each table using:

mdb-export database.mdb table_name

You can also convert the mdb into a format required by MySQL. First you must get the put the table schema into the database using the following command:

mdb-schema database.mdb | mysql -u username -p database_name

You then import each table by running:

mdb-export -I database.mdb table_name | sed -e ‘s/)$/)\;/‘ | mysql -u username -p database_name