https://issues.apache.org/ooo/show_bug.cgi?id=125655
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |DUPLICATE --- Comment #3 from Regina Henschel <[email protected]> --- If you do not have linked it to an external database engine, then likely the embedded HSQL engine is used. You should see "HSQL Database engine" in the status bar. This is a HSQL ver. 1.8. This database engine does not know a single command to export to csv. You need several steps: Create a HSQL "text table": CREATE TEXT TABLE Connect this text table to the desired .csv file and determine such things as delimiter and character encoding: SET TABLE Copy your data from your table into the new, and up to now empty, text table: INSERT INTO Perhaps delete the text table or disconnect it from the .csv file. Find details on text tables in http://hsqldb.org/doc/guide/ch06.html. That way will give you full control over the export. But perhaps this simple solution might already work for you: In menu Tools > SQL... Write command SELECT * INTO TEXT "<file name of export without .csv>" FROM "<name of table to be exported>" Click Execute The .csv file is generated in the same directory as the .odb file. Of cause you have to use your own names instead of the <..> parts. So "Cannot" is not correct. But you are right, it would be nice to have a UI for such export. But that is already tracked in issue 59369. There are other similar request mentioned there. *** This issue has been marked as a duplicate of issue 59369 *** -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
