Re: [libreoffice-users] Re: And while I'm here, data extraction

On Thu, Feb 5, 2015 at 1:40 AM, C&A Säger wrote: > Download this artbitrary database document with an embedded HSQLDB: > > https://forum.openoffice.org/en/forum/download/file.php?id=22304 > > Run this: > > SELECT * INTO TEXT "exportTable1" FROM "Table1" > > which creates exportTable1.csv in the

[libreoffice-users] Re: And while I'm here, data extraction

Download this artbitrary database document with an embedded HSQLDB: > https://forum.openoffice.org/en/forum/download/file.php?id=22304 Run this: > SELECT * INTO TEXT "exportTable1" FROM "Table1" which creates exportTable1.csv in the same directory where the document lives. -- View this messag

Re: [libreoffice-users] Re: And while I'm here, data extraction

On Wed, Feb 4, 2015 at 6:20 PM, Andreas Säger wrote: > Am 04.02.2015 um 01:26 schrieb Alan B: > > select * into text "newfile' from "Sheet1"; > > Well, it's obvious. Isn't it? > :-) when you put it that way. Gave me hope for a moment it was my error. Unfortunately I must have made a typo in my

[libreoffice-users] Re: And while I'm here, data extraction

Mark Stanton wrote > Hmm > > > Wild! I don't see a text export though, other than saving the Writer file > as > a text file. Well, yes. Saving in any other file format than ODF is an export indeed. So we can use Calc, Writer and the underlying database engine to export database data as plain tex

[libreoffice-users] Re: And while I'm here, data extraction

Le 03/02/2015 21:49, tonybsa a écrit : > > You do not select the cells from an open query. If you want individual records from your query result window, select the grey cell at the lefthand end of the grid. Use Ctrl-click to select non-contiguous results. With the rows highlighted, maintain th

[libreoffice-users] Re: And while I'm here, data extraction

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

[libreoffice-users] Re: And while I'm here, data extraction

Le 02/02/2015 12:34, Mark Stanton a écrit : > There seems to be no way to output *data* from Base, is that right? > Open a blank Calc document. Create a query. Run it. In the results window, select all or some of the records with the mouse button : - ALL : click on the upper left hand grey corner