Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


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: users+unsubscribe@global.libreoffice.org
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.