All geek questions in one place

How to access ODB files in Python 2.7

I want to access the ODB file (created using LibreOffice Base) in Python and extract the table for later use. An ODB contains several tables, one relationship design, and several forms.

Is it possible to achieve this without using SQL?

Edit: Since it seems too complicated to parse this format yourself, I will consider using the proper HSQLDB mechanism.

What is access to the python module through HSQL (e.g. sqlite3 for SQLite)?

+6
source share
2 answers

You might consider the Python Uno API that ships with OpenOffice. There are several Python examples for interacting with the API, including a sample database.

There is also this SO question , which explains how to use uno with LibreOffice.

+4
source

The ODB form by default contains the HSQLDB database. You can extract this database, then access it using the HSQLDB software and any client that can connect to HSQLDB.

Database extraction instructions can be found here: http://programmaremobile.blogspot.co.uk/2009/01/java-and-openoffice-base-db-through.html

+1
source

Source: https://habr.com/ru/post/919910/

More articles:


All Articles