Also, others may have also, but I wrote a small tutorial on doing this (exporting using TEXT TABLES) for the old OOo forums and that should be there still. I'll go this evening and see if I can find that and pass it onto you if I can find it.
On Thu, Mar 19, 2020 at 12:37 PM Drew Jensen <drewjensen.in...@gmail.com> wrote: > Howdy, > > Well, IMO, dumping the DB with a simple script command is great if you are > migrating the data but for exporting data: > > You need to look at the HSQLdb documentation on TEXT TABLES and the SELECT > INTO construct. > > Using that you can export all of a table or use the standard query > functions to export a subset of records or to join records from multiple > tables into a single export file. > > I hope that helps, > > Drew > > On Thu, Mar 19, 2020 at 12:26 PM Dan Lewis <elderdanle...@gmail.com> > wrote: > >> Page 6 of chapter 10 Database Maintenance contains this section. Can >> anyone explain how to actually do this? I can use SCRIPT 'database >> name'; and then SET SCRIPTFORMAT TEXT. This reduces the database folder >> within the *.odb file. But how do I use Tools > SQL after these two steps? >> >> Dan >> >> >> -- >> To unsubscribe e-mail to: >> documentation+unsubscr...@global.libreoffice.org >> Problems? >> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette >> List archive: https://listarchives.libreoffice.org/global/documentation/ >> Privacy Policy: https://www.documentfoundation.org/privacy >> > -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy