The mdbtools are super awesome, here's a quick example.

mdb-tables

Dump tables, or use a different delimiter.

~ # mdb-tables ./Desktop/Tooling.mdb
CA_Tools CB_Tools CMX CR_Tools CW_B CW_H CW_R

~ # mdb-tables -d, ./Desktop/Tooling.mdb
CA_Tools,CB_Tools,CMX,CR_Tools,CW_B,CW_H,CW_R,

mdb-export

Export the data as CSV or SQL, and patch it up. First the standard dump, then as SQL inserts (-I) and finally normalising table and field names (-S).

mdb-export /home/atom/Desktop/Tooling.mdb CA_Tools > ca.sql
mdb-export -I /home/atom/Desktop/Tooling.mdb CA_Tools > ca.sql
mdb-export -I -S /home/atom/Desktop/Tooling.mdb CA_Tools > ca.sql