Questions tagged [openoffice-base]

OpenOffice Base is the database management application of the OpenOffice project.

OpenOffice.org Base is the database management application of the OpenOffice.org project.

Since version 2.0 OpenOffice.org ships its own database HSQLDB. HSQLDB is a database written entirely in Java.

BASE is the database frontend of OpenOffice.org. Through drivers it can also communicate with other databases besides HSQLDB.

65 questions
0
votes
1 answer

Export from OO Base to M$ Access

As I understood it can export only in PDF, but i doesn't think that scanning PDF with Fine Reader, saving as text and then exporting to Access is the easiest way. The "Export" tab always inactive
khex
  • 2,778
  • 6
  • 32
  • 56
0
votes
2 answers

Not able to connect to OpenOffice Base - User lacks privilege or object not found Exception

I am trying to connect to an OpenOffice Base database from Java and execute a query, and have not been able to. These are the steps I followed: 1) Created a Database 'TestDB.odb' in OpenOffice, and a table 'Movies' with columns (ID, Name,…
Chillax
  • 4,418
  • 21
  • 56
  • 91
0
votes
1 answer

Simulate GROUP_CONCAT function in HSQLDB versions < 2?

LO/OOO Base doesn't come with an HSQLDB version > 2 which means there is no GROUP_CONCAT function. Is there a way to simulate this function in HSQLDB versions < 2? Here's an example for the columns name and value before the function is…
-1
votes
1 answer

Group two tables by month and make difference

I try to regroup data (with SQL) by months and make a subtraction (with groups by months). TABLE 1 : DATE MONEY1. 01/01/2023 30 10/01/2023 5 12/02/2023 30 18/02/2023 20 TABLE 2…
bloumk
  • 1
  • 1
-1
votes
1 answer

How to read the openoffice .sxc spreadsheet?

I need to to read the data in the openoffice .sxc spreadsheet. I have seen the openoffice java SDK to operation the openoffice. Indeed, it is difficult for me to understand. I need to loop the sxc spradsheet and read the cells. Please help me! Thank…
1 2 3 4
5