Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

I have a .mdb database file which originated from a MS Access Jet database.

Is the some way to view this database, and even better, a way to edit and export it?

share|improve this question
add comment

1 Answer

up vote 6 down vote accepted

You can try to install mdbtools and mdbtools-gmdb in order to get the mdb viewer for gnome.

alt text

I haven't used it myself, so i don't know if it's able to let you edit the database, but it gives you the option to export it, so maybe you can convert it to the oo-base version (odb).

I don't know why openoffice doesn't support it. I've read that is caused by MSDAO that cannot be installed in linux o/s, so only oo-base in windows can natively support it.

Anyway, you should give it a try i guess. I hope it helps a bit.

share|improve this answer
    
Thanks Pavlos.. mdbtools is currently read-only (according to [mdbtools.sourceforge.net/] it will become writeable in the next version (but the current version seems to be from 2004, so I'm not waiting :)... As it stands now, it is functional for reading data via SQL and can export individual tables, and schemas. It doesn't seem to handle the standard MS UTF-16 unicode format, unless it can via a locale setting, but it is quite usable for looking at and exporting tables.. There might be more to it, as I've only looked a the GUI, and the CLI may do more, but it has its merits as it is. –  Peter.O Dec 15 '10 at 19:18
    
glad to hear it helped ;-) –  Pavlos G. Dec 15 '10 at 19:40
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.