Opening an .accdb file in Ubuntu?

up vote
11
down vote

favorite

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.

asked Sep 8 '13 at 13:26

Alix Axel

4411825

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 a comment |

up vote
11
down vote

favorite

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.

asked Sep 8 '13 at 13:26

Alix Axel

4411825

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 a comment |

up vote
11
down vote

favorite

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.

asked Sep 8 '13 at 13:26

Alix Axel

4411825

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.

13.04 libreoffice file-format microsoft-office

asked Sep 8 '13 at 13:26

Alix Axel

4411825

asked Sep 8 '13 at 13:26

Alix Axel

4411825

asked Sep 8 '13 at 13:26

Alix Axel

4411825

asked Sep 8 '13 at 13:26

Alix Axel

4411825

asked Sep 8 '13 at 13:26

Alix Axel

4411825

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 a comment |

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

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 a comment |

4 Answers
4

active

oldest

votes

up vote
8
down vote

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.

answered Dec 10 '13 at 21:23

Ryan Davis

18113

add a comment |

up vote
2
down vote

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♦

answered Sep 8 '13 at 14:05

Stormvirux

3,7381831

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 a comment |

up vote
2
down vote

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♦

answered Sep 3 '14 at 12:30

Gord Thompson

7081612

add a comment |

up vote
0
down vote

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 at 10:13

Eduard Florinescu

2,08282842

add a comment |

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f342925%2fopening-an-accdb-file-in-ubuntu%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

4 Answers
4

active

oldest

votes

4 Answers
4

active

oldest

votes

up vote
8
down vote

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.

answered Dec 10 '13 at 21:23

Ryan Davis

18113

add a comment |

up vote
8
down vote

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.

answered Dec 10 '13 at 21:23

Ryan Davis

18113

add a comment |

up vote
8
down vote

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.

answered Dec 10 '13 at 21:23

Ryan Davis

18113

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.

answered Dec 10 '13 at 21:23

Ryan Davis

18113

answered Dec 10 '13 at 21:23

Ryan Davis

18113

answered Dec 10 '13 at 21:23

Ryan Davis

18113

answered Dec 10 '13 at 21:23

Ryan Davis

18113

add a comment |

up vote
2
down vote

For Access 2000-2011(both Read-Write)

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♦

answered Sep 8 '13 at 14:05

Stormvirux

3,7381831

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 a comment |

up vote
2
down vote

For Access 2000-2011(both Read-Write)

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♦

answered Sep 8 '13 at 14:05

Stormvirux

3,7381831

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 a comment |

up vote
2
down vote

For Access 2000-2011(both Read-Write)

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♦

answered Sep 8 '13 at 14:05

Stormvirux

3,7381831

For Access 2000-2011(both Read-Write)

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♦

answered Sep 8 '13 at 14:05

Stormvirux

3,7381831

edited May 23 '17 at 12:39

Community♦

edited May 23 '17 at 12:39

Community♦

edited May 23 '17 at 12:39

Community♦

answered Sep 8 '13 at 14:05

Stormvirux

3,7381831

answered Sep 8 '13 at 14:05

Stormvirux

3,7381831

answered Sep 8 '13 at 14:05

Stormvirux

3,7381831

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 a comment |

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

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 a comment |

up vote
2
down vote

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

edited Apr 13 '17 at 12:24

Community♦

answered Sep 3 '14 at 12:30

Gord Thompson

7081612

add a comment |

up vote
2
down vote

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

edited Apr 13 '17 at 12:24

Community♦

answered Sep 3 '14 at 12:30

Gord Thompson

7081612

add a comment |

up vote
2
down vote

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

edited Apr 13 '17 at 12:24

Community♦

answered Sep 3 '14 at 12:30

Gord Thompson

7081612

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

edited Apr 13 '17 at 12:24

Community♦

answered Sep 3 '14 at 12:30

Gord Thompson

7081612

edited Apr 13 '17 at 12:24

Community♦

edited Apr 13 '17 at 12:24

Community♦

edited Apr 13 '17 at 12:24

Community♦

answered Sep 3 '14 at 12:30

Gord Thompson

7081612

answered Sep 3 '14 at 12:30

Gord Thompson

7081612

answered Sep 3 '14 at 12:30

Gord Thompson

7081612

add a comment |

up vote
0
down vote

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 at 10:13

Eduard Florinescu

2,08282842

add a comment |

up vote
0
down vote

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 at 10:13

Eduard Florinescu

2,08282842

add a comment |

up vote
0
down vote

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 at 10:13

Eduard Florinescu

2,08282842

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 at 10:13

Eduard Florinescu

2,08282842

answered Nov 29 at 10:13

Eduard Florinescu

2,08282842

answered Nov 29 at 10:13

Eduard Florinescu

2,08282842

answered Nov 29 at 10:13

Eduard Florinescu

2,08282842

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Ask Ubuntu!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Cfxtrjtrk