Skip to content

Access .mdb files on Linux

March 26, 2007

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.

About these ads
7 Comments
  1. duh saya belum bisa pakai access nih, jadi belum perlu yah sepertinya. :D

  2. wah lama nyari artikel kayak gini nggak pernah ketemu

  3. Is this purely conversion or an editing tool?

  4. farvish permalink

    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

  5. tapi gak bisa read-write… read doang… gimana supaya bisa write?

  6. 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!

  7. vasundhar permalink

    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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: