Use Libre Base to open Access DB file

HuaMin Chen
HuaMin Chen used Ask the Experts™
on
Hi,
I have a problem to open Access Database file, using Libre Base. Any advice?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jackie Man IT Manager
Top Expert 2010

Commented:
You can not import or open a MS Access database into Base. You can however get access to the Tables in the MS Access database. there are two ways:-

1) In LO select create a new Base Database. In the wizard select "Connect to an existing database". Select "Microsoft Access" from the drop down list and select the MS Access database file. You will then see the Tables in the MS Access database.

2) If you want to use a Base database stand alone without having it connected to the MS Access file then after creating the connected database as in 1, with that database left open create another new standard Base database. Select each Table in turn in the connected database copy and then paste into the standard database.

In both cases you will need to create new Forms, Reports, and Queries in the base databases as these elements can not be imported from the Access database.

Source: https://ask.libreoffice.org/en/question/64915/can-base-import-a-database-i-created-using-ms-access/

In short, it is better to install MS Access unless you need the raw data only.
HuaMin ChenProblem resolver

Author

Commented:
Hi Jackie,
Are you able to open this Access file below, using LibreOffice Base?

https://app.box.com/s/zjmxbhqp9p5x902xvx1pp5da9arr48fn
Jackie Man IT Manager
Top Expert 2010

Commented:
As your MS Access database is in .accdb format, you can follow the YouTube video in the link below for how to open it in BASE.

https://youtu.be/McTXBrqwN_c
HuaMin ChenProblem resolver

Author

Commented:
Dear Jackie,
Do you have the full steps, to achieve this, instead of a You tube video?
IT Manager
Top Expert 2010
Commented:
"Step 1 -- Open data source administrator

In this tutorial, we have created a simple database file in access with the ".accdb" extension. Open office doesn't recognize the .accdb extension. So we will have to open up the odbc data source administrator window first.

Step 2 -- ODBC Data Source Administrator via run

Another way to do so is by pressing the "win+r" key in order to open up the run command and over there, type in in odbcad32. This will open up the ODBC Data Source Administrator Window.

Step 3 -- Go to System DNS tab

Over there, go to the System DNS tab and then click on the Add button.

Step 4 -- Select Ms Access driver

Scroll down and select the Microsoft Access Driver option. Once you are done, simply click on the finish button.

Step 5 -- Click on the select button

This will open up the ODBC Microsoft Access Setup Window. Over here, click on the select button.

Step 6 -- Locate the database file

Now we will locate the data base file which we created earlier. Once done, simply click on the ok button.

Step 7 -- Insert Data Source Name

With that done, you will be taken back to the previous window and over there, simply type the name in the data source name field. Once you are done, click on the OK button.

Step 8 -- Database option

With that done, open up Open office and in the main screen over there, click on the database option.

Step 9 -- Connect to existing databaes

Now the Open Office database Wizard window will open up. Over there, choose the "connect to an existing database" option and from the drop down menu, select the ODBC option. With that done, you can move on to the next step.

Step 10 -- Select the database

Over there, click on browse and select the database you want to work on.

Step 11 -- Save in open office extension

With that done, simply click on the finish button and you will be prompted to save the Microsoft access database in the open office extension.

Step 12 -- Ms Access files in Open Office"

The above are copied from the full description of the YouTube video as mentioned in my previous comment.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial