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.