Opening an .accdb file in Ubuntu?

Question

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.

@SauravKumar: Yes, I even installed the additional ODBC plugins, but it doesn't to work with .accdb files. — Alix Axel, Sep 08 '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 08 '13 at 16:48

score 11 · Answer 1 · edited Dec 21 '20 at 20:01

11

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

edited Dec 21 '20 at 20:01

Pablo Bianchi

15,657

answered Dec 10 '13 at 21:23

Ryan Davis

239
2
5

score 3 · Answer 2 · edited May 23 '17 at 12:39

3

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

edited May 23 '17 at 12:39

Community

1

answered Sep 08 '13 at 14:05

Stormvirux

4,466

Thanks, but both seem to be programming APIs, right? Having a GUI would be nice, or a simple CLI at least. – Alix Axel Sep 08 '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: http://askubuntu.com/questions/187389/is-it-possible-to-open-a-office-2010-access-files and http://askubuntu.com/questions/284359/can-microsoft-access-files-be-edit-in-ubuntu?lq=1 – Stormvirux Sep 08 '13 at 18:46

score 3 · Answer 3 · edited Apr 13 '17 at 12:24

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?

edited Apr 13 '17 at 12:24

Community

1

answered Sep 03 '14 at 12:30

Gord Thompson

1,020

score 2 · Answer 4 · answered Nov 29 '18 at 10:13

2

To export all the tables on Linux to CSV format try this command:

mdb-tables -d ',' database.accdb| xargs -L1 -d',' -I{} bash -c 'mdb-export database.accdb "$1" >"$1".csv' -- {}

You can use mdbtools also into windows via WSL (Ubuntu on Windows or Debian on Windows): Then install it in console with:

sudo apt install mdbtools

answered Nov 29 '18 at 10:13

Eduard Florinescu

8,047

Error: Table does not exist in database – mLstudent33 Dec 04 '20 at 22:14

score 0 · Answer 5 · answered Dec 21 '20 at 19:53

0

I just had success with mdb-tools v0.99 and this bash script

https://github.com/pavlov99/mdb-export-all

bash mdb-export-all.sh full-path-to-ms-access-db.accdb

answered Dec 21 '20 at 19:53

Sergio

240
3
10

Opening an .accdb file in Ubuntu?

5 Answers5

Linked

Related