openoffice.orghsqldbfile-conversion

OpenOffice spreadsheet import into HSQLDB


OpenOffice ships with HSQLDB. Is it possible to easily import the contents of an OO spreadsheet into the built in database? An added nice to have would be to include the formatting of the cell contents. ie. colors, line feeds, etc.

The provided link does work, and no coding is required. To summarize:

  1. Create and register an Open Office DB.
    1.1 Looks like you can register any DB for which you have a JDBC driver. (ie. MySql,Postgres)
  2. Create column headings in row 1.
  3. Select data and copy it to the clipboard.
    3.1 Limited selection to only the desired rows because OO crashed when I selected all rows.
  4. Go to the Table (Tables pane) view of the database.
  5. Right-click and paste your data.
  6. Follow the instructions provided by the wizard that opens.

Solution

  • I don't know if you would call it easy, but apparently there are ways to import data into open office's base database.

    This article explains how to manually import data into the database. And this article has more pretty pictures for the same process. One reason you may not be getting the answer that you want, is that there is very little detail in your question. You could add some more and maybe someone out there can help.