Created attachment 119677 [details] database (odb) I have starting compiling a database however I am unable to find an option enabling me to export the database to a format that can be read by another application including Microsoft Excel, since I would like to use other software to analyze the training data as it grows. Basically we need an export tool within LibreOffice Base. Further reading 1. http://docs.oracle.com/javase/tutorial/jdbc/basics/index.html 2. https://msdn.microsoft.com/en-us/library/ms710252(v=vs.85).aspx
ODB is a file format container, containing more than just database tables or references thereto. It is not intended, and never has been intended, to provide an export option of the ODB file to another format, much in the same way that you can not save an Access file mdb or accdb as another database format. If you are looking to export data from your tables or produced by queries to a tabular format, this is already provided by the LibreOffice Base application by copying/pasting or dragging/dropping to a Calc sheet and saving as Calc/Excel/CSV. You can even use Calc directly to reference a db data source (db range), and the save this sheet as Excel, CSV, etc In the default embedded hsqldb database, an ODB file contains a script and binary data accessible to hsqldb. There are tutorials in the OpenOffice.org forums which explain how to move an embedded hsqldb ODB to an external hsqldb server instance.