Ask Your Question
1

Using Mac LIBREOFFICE and opening an ACCESS .mdb or .ACCDB file

asked 2015-03-12 06:34:20 +0200

jmm123 gravatar image

I have just started using Mac LIBREOFFICE in the hope that I could open an ACCESS .mdb or .ACCDB file.

Looks like this cannot be done. I have an ODBC utility for the Mac but there is nothing to help connect to Access.

hope someone can help.

Thanks, John

edit retag flag offensive close merge delete

Comments

You would need to use the separate ODBC utility to add MS Access sources, and then they would be available to LO through a new ODBC connection. Does that work?

doug gravatar imagedoug ( 2015-03-12 06:55:20 +0200 )edit

The ODBC utility does not have ACCESS for Mac. Could someone please direct me to one for the Mac

jmm123 gravatar imagejmm123 ( 2015-03-13 00:43:06 +0200 )edit

I get hits in a search engine with those search terms, and see a $40 solution that I have not tested. I would not expect to see an open source solution for those specific platforms.

doug gravatar imagedoug ( 2015-03-13 16:28:55 +0200 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2016-10-07 05:31:06 +0200

EasyTrieve gravatar image

You might want to try using mdbtools. There is a ODBC driver for *.mdb files. Go to: http://mdbtools.sourceforge.net/

(Using this I can get at my Access files from MariaDB, but so far because of ODBC to LibreOffice Base connector failures, I can't actually use the database directly in LibreOffice Base.)

edit flag offensive delete link more
0

answered 2015-03-14 23:41:52 +0200

doug gravatar image

ODBC is middleware. LO conects to it, other vendors would be responsible for making sure their own software connects to it too. Lack of interoperability is a reason I stopped using Access (and switched to MySQL/MariaDB backend, not LO HSQLDB).

If you are porting from Access permanently, I would suggest outputting the database into another format, for example csv or dBase files, and then importing into LO for native use, or some other backend on Mac that does have ODBC or JDBC drivers. Instructions for importing data into LO base from spreadsheets is available here.

edit flag offensive delete link more
0

answered 2015-03-13 00:42:15 +0200

jmm123 gravatar image

Hi, The ODBC utility does not have an ACCESS source. I would gladly buy one IF I knew that it would work easily. and if it had GOOD documentation

Looks like the docs refer to ACCESS connections if you have Windows or Linux but not for Mac. Someone must have worked this out by now

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-03-12 06:34:20 +0200

Seen: 4,518 times

Last updated: Oct 07 '16