Ask Your Question
0

Importing MS Access tables into Base 5.1.6.2, No option works. Using Linux Mint.

asked 2017-04-06 22:24:37 +0200

Edward2 gravatar image

updated 2017-04-06 23:24:02 +0200

All of the (old) posts I'm reading refer to a 'Connect to an existing database' choice of 'Microsoft Access', but the MS Access choice Does Not Exist in my Libreoffice Base version 5.1.6.2.

I am testing the ODBC selection, but it produces an error:

Could not load the program library libodbc.so.1 or it is corrupted. The ODBC data source selection is not available.

I also tried to use the dBase import selection, but did not function. The dBase files browsed to were all grayed-out and appeared to not be accepted by Base.

Making Importation of Access and other DB formats simple would be a gigantic asset to Libre, I would think.

What would be the best fix?

Any advice appreciated.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-04-06 22:35:48 +0200

Ratslinger gravatar image

updated 2017-04-06 23:55:49 +0200

It is my understanding this is available when using Windows OS. Personally I use Linux and it is not available. Instead, I use the UCanAccess connector - click here for link. Keep in mind, any connection will not have access to any forms.

In answer to the modified portion of question (ODBC) this older post may help - click here.

Edit:

UCanAccess is a JDBC connector which works fine in Mint 18. Here are some further instructions on installation - click here.

If this answers your question please click on the ✔ (upper left area of answer).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-04-06 22:24:37 +0200

Seen: 843 times

Last updated: Apr 06 '17