Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Openoffice Base (Read 2149 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Openoffice Base
05.01.09 at 09:24:23
Openoffice Base
Openoffice Base is the Open Office equivalent for MS Access. Open office can be downloaded (free) from
I have not been able to find a way to connect to Openoffice's Base through ODBC or OLEDB. I did read some suggestions to try the ODBC - JDBC gateway and use a JDBC driver but I have not tried that.
This is a summary of what I have read about Openoffice Base:

  • Base maintains its files in an Open Document Format: a zipped bunched of XML files and attachements.
  • ODF is used for the reports, forms, etc.  
  • The database itself is stored inside the ODF container as a binary attachment
  • The D/B engine is the Java based database HSQL
  • The D/Bs binary format is the native HSQL format.
  • Manipulating an ODB database involves unzipping the entire D/B, manipulating it then zipping it up again to save it.

Back to top
« Last Edit: 05.01.09 at 09:28:11 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1