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
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?
The ODBC utility does not have ACCESS for Mac. Could someone please direct me to one for the Mac
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.
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
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.
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.)