Active9 months ago
The development machine I work on has Ubuntu Jaunty Jackalope as its operating system. I have been presented with data for a project I'm working on in the form of an .accdb file created by Microsoft Access. I do not own a copy of Microsoft Access. I do have Open Office installed and would be willing to install any software package available to my operating system. Is there a way I can open or transform this file so that I can view and edit the data on my computer? Is there another format that the Access database could be saved as that I would be able to open?
This Access ACCDB Viewer Tool for Windows supports multiple versions such as 10, 8.1, 8, XP, etc. The software is compatible with different versions of MS Access and ACCDB database files created in Access of versions 2007 & above are fully supported by the tool. Up until recently, there was no way to open a Microsoft Access database directly on a Mac. However, there are, at the time of writing, five apps, all available from the Mac App Store, which allow you to open and view data in Access database tables.
pgwilliapgwillia
8 Answers
There are two open source tools available however they only work on MDB format files. Can you ask the supplier of the ACCDB file to give it to you in MDB format?
Accdb Reader For Mac Microsoft Office
MDB Tools is a set of open source libraries and utilities to facilitate exporting data from MS Access databases (mdb files) without using the Microsoft DLLs.
Sony Reader For Mac
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.
Tony Toews![Reader Reader](/uploads/1/2/6/0/126062627/549386641.jpg)
7,51111 gold badge1717 silver badges2525 bronze badges
Jackcess now supports everything from Access 97 (read-only), 2000, 2003, 2007, and 2010 (read-write), both .mdb and .accdb files.
Dumping the file can be as easy as
(of course, you need a java compiler, libcommons-logging-java, libcommons-lang-java and you have to pass the .accdb filename as the first and the table name as the second parameter).
-Marcel
Marcel WaldvogelMarcel Waldvogel
E-reader For Mac
I just had this same problem on an Ubuntu 14.01 AWS EC2 instance and I was able to accomplish this task (convert
.accdb
file to CSV on Ubuntu) by using access2csv. I had to install Git, install Java, and install ant, but then was able to convert the .accdb
files I had to CSV
by typing:$ java -jar access2csv.jar myfile.accdb
It uses Jackcess so you get the same functionality without having to write your own Java code to accomplish this basic task. Each table is returned as its own
CSV
file. You can also access the schema by passing the
--schema
option:java -jar access2csv.jar myfile.accdb --schema
Hope this is helpful. It certainly was for me.
Richard DRichard D
A good format to view and work with on Linux would be CSV.
As the accepted answer suggests MDB Tools does the job. To export all the tables on Linux to CSV format try this command:
You can use
Eduard FlorinescuEduard Florinescumdbtools
also into windows via WSL (Ubuntu on Windows or Debian on Windows):Then install it in console with:6,1162323 gold badges8484 silver badges146146 bronze badges
This may be of interest: How to convert accdb to a postgres database
I am not sure if
Wine
would suit, but it might be worth a look.Community♦
FionnualaFionnuala85.8k77 gold badges9696 silver badges133133 bronze badges
I guess you want to extract data from tables, not code from modules. I do not know specifically Ubuntu but I guess you can connect to the access file using an ODBC connection (or, if available, OLEDB connection) and extract the data? Depending on the connection type, you might still need to know the tables names in order to import them.
Philippe Grondier![For For](/uploads/1/2/6/0/126062627/823549419.jpg)
9,27222 gold badges2222 silver badges6262 bronze badges
Microsoft Access Runtime is a free software. You can install it in Ubntu using Wine and then open the accdb database.
MakadaMakada
Im not sure if there are any native tools, but you can always install a copy of windows and install a free view for accdb files or install a trial of Access.
HenriHenri