Currently it is not possible to export database tables from within Base to a file. The only way to export tables is to drag&drop the table to an open Calc window. See [1]. The only alternativeto export tables is to connect to a writable data source (e.g. spreadsheet tables are not writable) and drag&drop the table to the other LO Base window. This is very cumbersome. Base is not able to just export to a file. Enhancement request: (1) Allow via "File" -> "Export" and via right mouse click on a database table to export the table(s) to a file (e.g. .ods) (2) Support for the export all file formats that are supported by LibreOffice Calc. (3) Allow also the export of multiple database tables at the same time, as they could be saved in the target file format also as different table or as different spreadsheet tab. [1] https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base
Can confirm this "bug" - isn't a buggy behavior but a feature request. One hint: You could also export by direct SQL SELECT * INTO TEXT "Table_outside" FROM "Tableinside" You will get a *.csv-file of the table (or the whole query). This could work by the right mouseclick on the table - but there couldn't be exported one file for all tables with File → Export - it's impossible with *.csv.
Adding self to CC if not already on
This is very important that Base export to CSV, etc. because Calc only have 1 048 576 rows while Base table could have more rows.