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've received a Microsoft Access .accdb file (version 2010 I believe) that I need to get some data from.

How can I open it in Ubuntu? Is there any tool that would allow me to do so?

PS: Read-only is fine, if it has CSV exporting capabilities, the better.

share|improve this question
    
Did you try LibreOffice Database to open it. –  Saurav Kumar Sep 8 '13 at 13:44
    
@SauravKumar: Yes, I even installed the additional ODBC plugins, but it doesn't to work with .accdb files. –  Alix Axel Sep 8 '13 at 16:44
    
I had a doubt.. Actually, I opened it very long time ago.. I don't remember what did I use.. Thought that it would be OpenOffice Database. Now cleared!! –  Saurav Kumar Sep 8 '13 at 16:48
add comment

2 Answers 2

I just released an access2csv program based on Jackess. Code is at https://github.com/AccelerationNet/access2csv, a binary is available at https://github.com/AccelerationNet/access2csv/releases.

share|improve this answer
add comment

For Access 2000-2011(both Read-Write)

Jackcess is a pure Java library for reading from and writing to MS Access databases. It is part of the OpenHMS project from Health Market Science, Inc. . It is not an application. There is no GUI. It's a library, intended for other developers to use to build Java applications. It appears to be much newer than MDB tools, is more active and has write support.

Jackcess currently supports 2000-2010 files for read and writing but only reading for Access 97 files

For Older 97 Access (both Read-Write)

Try MDB Tools

Source

share|improve this answer
    
Thanks, but both seem to be programming APIs, right? Having a GUI would be nice, or a simple CLI at least. –  Alix Axel Sep 8 '13 at 16:46
    
@AlixAxel Libre Office has support till access 2007 but doesmt support 2010.Easy solution would be saving as 07 and using libre office. btw check this out: askubuntu.com/questions/187389/… and askubuntu.com/questions/284359/… –  Stormvirux Sep 8 '13 at 18:46
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.