Macro to import base table into spreadsheet

menu:Edit>Database>Properties…

In case of JDBC: menu:Tools>Options>Advanced (or Java in OO), button [Class Path]
The driver class name is “com.mysql.jdbc.Driver” in the database properties

Can you open this database?

Sorry for the long delay and thank you for your help. In fact I did not get notification of your answer. After the holidays I started a new question in the same subject and finally the connection problem was resolved, see Cannot connect to mysql - #8 by RobertG
To answer to your question: NO, I cannot open “this database”. It has to do with the embedded database, see the other post referenced above. As mentioned in the other post, such file can be opened in OO in my Gentoo desktop, including your “this database”.

jankom

menu:Help> About LibreOffice…
Click the copy button in the middle and paste here.

But for @jankom

@jankom

For future reference @Villeroy is referring to the icon clearly shown in your screen capture next to the text Version Information. As was mentioned, you can click that icon to copy the version information below it.

Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.4
Calc: threaded

OK, I changed the name by removing “cj”, and it still connects with my other ODB files. However, your PowerFilter.odb would not connect. In fact, if I open that file Edit / Database … has only the third selection available (Advanced settings), the other two are grayed out. I edited the driver class name with another odb file but I still cannot show tables in your odb file:

Screenshot at 2024-01-12 05-02-10.png

jankom