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

On Tue, Feb 3, 2015 at 6:55 AM, Mark Stanton <mark@vowleyfarm.co.uk> wrote:

> Having said all of that, is it ideal that the only way to get a data
> output from Base is C'n'P?


No it isn't, not at all. Having used dBase, FoxPro, Paradox and Access and
others I can attest that all had multiple result export methods.

I would appreciate export in Base also. Unfortunately don't have the skill
to code it or the cash to fund development so am left with what is.

After a little bit of digging I did find that HSSQL does offer means to
export data. So it "may" be possible to use the SQL command line in Base to
perform your exports. I write "may" because not all commands I've run at
the SQL command line seem to be executed as I would expect.

And this method certainly isn't as trivial as an "Export to" option in the
UI would be. In any case perhaps this link can help you accomplish your
goal...
http://hsqldb.org/doc/2.0/util-guide/sqltool-chapt.html#sqltool_csv-sect

-- 
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