Access .mdb files on Linux
MDB Tools is a set of utilities for accessing MS Access (duh) .mdb files on Linux. One of its most important feature is the ability to export the data into various database engines including, but not limited to, MySQL, Postgres and Oracle[1]. It also packs you a nice (gtk based) graphical interface for your clicking pleasure. You can find a nice tutorial on using mdbtools at the Oracle website.
To fellow Ubuntu users: The mdbtools package is available in the Ubuntu repositories, so installation would be pretty much painles. Just install mdbtools via Synaptic or run apt-get install mdbtools (you probably need to enable Universe).
So yes people, it is _very_ easy to migrate your old MS Access based database to non-ms database engines. Have fun!
[1] Please take note that MDB Tools currently exports .mdb data into CSV (text) files. But It can export the schema (DDL) to other database engiens. Converting the CSV data into SQL insert statements is pretty much trivial.
solaris 
duh saya belum bisa pakai access nih, jadi belum perlu yah sepertinya. :D
wah lama nyari artikel kayak gini nggak pernah ketemu
Is this purely conversion or an editing tool?
Nice article. I didn’t knew that i can use access on linux. You can check more more resources on access http://offficerepair.wordpress.com. Some times access database get corrupted in this situation you can use access repair utility.
More information on htp://www.reapir-access-file.com
Thank you
tapi gak bisa read-write… read doang… gimana supaya bisa write?
You’re so cool! I do not believe I’ve truly read through anything like that before. So nice to discover another person with some unique thoughts on this subject. Really.. many thanks for starting this up. This web site is something that’s needed on the web, someone with some originality!
Hi There is an option to export as insert statements “-I” and you need to put flag not to export headers -H for the export you can find it on the link http://vasundhar.blogspot.in/2011/04/mdbtools-to-import-to-mysql-or-any.html
Thanks for every other excellent article. The place else may just
anyone get that type of info in such an ideal manner of writing?
I’ve a presentation next week, and I am on the look
for such information.