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