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

安装一个工具，mdbtools，地址：http://mdbtools.sourceforge.net/，ubuntu应该可以直接安装，archlinux在aur中有。

具体使用方法：

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