Re: [libreoffice-users] Re: export sql to odb?
Hi :) +1 The Documentation Team are working on a Base Guide but it's very difficult. Any help would be appreciated. The type of guide being worked on right now is to fit on this page http://wiki.documentfoundation.org/Documentation along with the guides for the other apps. At the very bottom of the page is a good place to add links to other useful stuff. Feel free to add links or/and join the docs team to perhaps get even more involved. Regards from Tom :) From: Dave Sergeant d...@davesergeant.com To: users@global.libreoffice.org Sent: Mon, 15 August, 2011 9:33:17 Subject: [libreoffice-users] Re: export sql to odb? Perhaps drifting off thread a little. I have a DBF database which dates back many years - in fact to Lotus Works in MS DOS days. It works well via LO Base, once one has worked out how to do it, which is far from obvious. I have often wondered whether it is worth converting this to a native LO database, ie on the lines of your mentioned HyperSQL. I guess it is not, and in fact I would guess that most users only use Base as an interface to other database formats. The 'Help' in LO, practically identical to that in OOo, is far from helpful and is pretty short of practical guidance. Every time I look at it it leaves me confused. Maybe an 'idiots guide' to using Base in real life situations, as part of the installation, is long over due. It would reduce all these sorts of threads. Dave On 15 Aug 2011 at 16:24, Simon Cropper (The foss Workflow Guides) wrote: Base is primarily a translator between various backends and LibreOffice. It does however use HyperSQL [1, 2] to create stand alone databases. [1] http://hsqldb.org/ [2] http://hsqldb.org/web/hsqlUsing.html This is a relational database engine written in Java. http://www.davesergeant.com -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: export sql to odb?
Hi I used many years ago access data base and I remember that you can export de data base to spreadsheet (excel). Then you would do: 1) Open Base program and open directly the excel spreadsheet and save as data Base. or 2) Open the excel spreadsheet with Calc, save as .ods and then open Base and import the spreasheet .ods. Both methods permit change your original data base to native LO Data Base. Regards, Jorge Rodríguez ___ El lun, 15-08-2011 a las 09:33 +0100, Dave Sergeant escribió: Perhaps drifting off thread a little. I have a DBF database which dates back many years - in fact to Lotus Works in MS DOS days. It works well via LO Base, once one has worked out how to do it, which is far from obvious. I have often wondered whether it is worth converting this to a native LO database, ie on the lines of your mentioned HyperSQL. I guess it is not, and in fact I would guess that most users only use Base as an interface to other database formats. The 'Help' in LO, practically identical to that in OOo, is far from helpful and is pretty short of practical guidance. Every time I look at it it leaves me confused. Maybe an 'idiots guide' to using Base in real life situations, as part of the installation, is long over due. It would reduce all these sorts of threads. Dave On 15 Aug 2011 at 16:24, Simon Cropper (The foss Workflow Guides) wrote: Base is primarily a translator between various backends and LibreOffice. It does however use HyperSQL [1, 2] to create stand alone databases. [1] http://hsqldb.org/ [2] http://hsqldb.org/web/hsqlUsing.html This is a relational database engine written in Java. http://www.davesergeant.com -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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