You must not copy any opened table or query. You copy and paste the _icon_ of a query or table. You can also link record sets to spreadsheet ranges and pivot tables which gives quite a powerful "report engine".
[Tutorial] Using registered datasources in Calc <https://forum.openoffice.org/en/forum/viewtopic.php?f=75&t=18511> You do not tell us which database you are using (no, Base is _not_ a database). If it happens to be an embedded HSQLDB (indicated on the status bar) then you can use this command: SELECT * INTO TEXT "export" FROM "Table or View" This uses the HSQL database engine to export all records of some named table or view into a text file named "export.csv" in my Linux home directory. The full documentation of your database program can be found here: http://www.hsqldb.org/doc/1.8/guide/ch09.html Finally you can drag a record set from the data source window into a Writer document and choose "Text" export. In that dialog you can concatenate the wanted fields in one line with some delimiter between the fields. Then save as plain text. -- View this message in context: http://nabble.documentfoundation.org/And-while-I-m-here-data-extraction-tp4138570p4138689.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
