Arch Linux

Blind

Member

From: Desert mountain

Registered: 2005-02-06

Posts: 386

Convert MS Access .mdb file

Hi,

although I am not quite a Linux newbie, I am a newbie to databases. And since there are no stupid questions here....

I am trying to convert a .mdb file into something that can be read by koffice. I am doing that for somebody else, and I am using XFCE not KDE, so I wanted to avoid installing it and imagined that things would be fine if I just installed mdbtools, which I did (0.6pre1).

Now, install succeeded and I imagined I could use one command to just convert from one file format to the next. Obviously, I was mistaken. Now I got as far as to use the mdb-scheme tool to make a scheme (?!). But now I am confuse - what next is there to do? mdb-export didnt work, or at least I dont know how, and the documentation on mdbtools is - to say it in a friendly way - worth of extending.

I am not a geek with databases at all, I just want to get the data into a Linux readable format.

Could somebody please help me out as to how to proceed?

Thanks in advance,
Blind

Last edited by Blind (2007-02-10 20:43:01)

skottish

Forum Fellow

From: Here

Registered: 2006-06-16

Posts: 7,942

Re: Convert MS Access .mdb file

Does this help?

http://www.koffice.org/filters/1.5/kexi/mdb.php

Cotton

Member

From: Cornwall, UK

Registered: 2004-09-17

Posts: 568

Re: Convert MS Access .mdb file

The package Knoda in the AUR will enable you to open mdb files then save the tables in an alternative format.