Opening an .accdb file in Ubuntu?

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.

Solution 1:

I just released an access2csv program written in Java based on Jackess. Code is here, a binary is available here.

Solution 2:

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

Solution 3:

It is also possible to use the UCanAccess JDBC driver to connect to Access database files (.mdb and .accdb) from applications like LibreOffice Base. For detailed instructions on how to set it up, see my answer to

Is it possible to open an Access 2010 database file without using Wine or VirtualBox?