this post was submitted on 07 Jun 2024
7 points (100.0% liked)

LibreOffice

362 readers
2 users here now

LibreOffice is a powerful free and open source office suite, used by millions around the world.

founded 1 year ago
MODERATORS
[email protected]
7
LibreOffice Base export (lemmy.world)
submitted 2 months ago by [email protected] to c/[email protected]
2 comments fedilink hide all child comments
 

I have created a database usimg HSQLDB and I am having trouble exporting this to a * .db for python.

Does anyone know what I am doing wrong? (The file>export buton is disabled...)

top 2 comments
sorted by: hot top controversial new old
[–] [email protected] 0 points 2 months ago (1 children)

Exporting data from Base

You copy a table from Base to a new Calc sheet, then you can save or export the data to any file format that Calc supports.

  1. Open the database file that contains the database table to be exported. Click Tables to view the tables, or click Queries to view the queries.

  2. Choose File - New - Spreadsheet.

  3. In the Base window, right-click the name of the table to export. Choose Copy from the context menu.

  4. Click cell A1 in the new Calc window, then choose Edit - Paste.

Now you can save or export the data to many file types.

https://help.libreoffice.org/6.2/en-US/text/shared/guide/data_im_export.html

[–] [email protected] 1 points 2 months ago

Thank you.

What's the file>export button for?