Displaying OpenOffice Base data in Excel

0

Is this possible? I assume I need an ODBC driver or other recognised from Excel/Query to access Base.

Jeff

Posted 2011-05-09T13:52:31.537

Reputation: 1

Answers

0

I don't think it is possible, at least not easily. OO Base is a front end that actually uses HSQLDB as its database engine. There is this thread in the OO community forum where a workaround is proposed to unzip your .odb file and use JDBC to connect to the HSQLDB database. (I haven't tried this). The OO forum thread is a bit old, so it might be a good idea to try to find alternatives.

Uros Calakovic

Posted 2011-05-09T13:52:31.537

Reputation: