I am trying to query an existing MicroSoft Access database
but cant seem to get to the database
how do I set this up to do a query
Query existing MicroSoft Access database
Query existing MicroSoft Access database
New here,
I am trying to query an existing MicroSoft Access database
but cant seem to get to the database
how do I set this up to do a query
I am trying to query an existing MicroSoft Access database
but cant seem to get to the database
how do I set this up to do a query
OpenOffice 4 on Windows 10
-
Hagar Delest
- Moderator
- Posts: 32658
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: MS Acess database
Hi and welcome to the forum!
Just to clarify: do you try to do it in AOO or with MS Access? In latter case, a MS forum may be more relevant.
Just to clarify: do you try to do it in AOO or with MS Access? In latter case, a MS forum may be more relevant.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: MS Acess database
menu:File>New>Database...
[X] Connect to existing database
Type: MS Access
[X] Connect to existing database
Type: MS Access
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: MS Acess database
Alternative approach for all operating systems:
Download UcanAccess and extract it to some place.
In the Java options of your office suite, click [Class Path...] and add the file ucanload.jar in subfolder "loader".
Restart the office.
Create a new database document and connect it to a new database of type "JDBC".
URL is ucanaccess://path/to/access_database.accdb
Driver class is net.ucanaccess.jdbc.UcanloadDriver
The driver imports existing Access queries as views.
This is a screenshot of a database document connected to Microsoft's "Northwind" demo on Linux.
Download UcanAccess and extract it to some place.
In the Java options of your office suite, click [Class Path...] and add the file ucanload.jar in subfolder "loader".
Restart the office.
Create a new database document and connect it to a new database of type "JDBC".
URL is ucanaccess://path/to/access_database.accdb
Driver class is net.ucanaccess.jdbc.UcanloadDriver
The driver imports existing Access queries as views.
This is a screenshot of a database document connected to Microsoft's "Northwind" demo on Linux.
- Northwind_UcanAccess.png (101.19 KiB) Viewed 1681 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice