LibreOffice

389 readers

3 users here now

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

founded 1 year ago

MODERATORS

submitted 5 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...)

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 0 points 5 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.

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.
Choose File - New - Spreadsheet.
In the Base window, right-click the name of the table to export. Choose Copy from the context menu.
Click cell A1 in the new Calc window, then choose Edit - Paste.

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

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

Thank you.

What's the file>export button for?