OpenOffice
J. Agoston (Sat, 19 Sep 2009 02:56:04 PDT)
Relational aspects rebuild:
Go into queries, select the query and then right click, choos the 2nd
option. Than on the upper menu line choose the third (View?) main menu
and then choos the 2nd menu (SQL view?), cut and paste, that is all.
If you can program in SQL you can add more to this part becouse the
menus and wizzards contain only the most used programming parts.
Of course you have to export the data tables to XLS or other data
formats than you have to rebuilt the relations with the "INNER JOINT"
etc...
Sorry for being complicated but I have the Office only in my own
laguage, not in english.
Bye,
Jan
2009/9/18 J.E. Shields <jshields@indy.net>:
I have found that the database in OpenOffice will not read in my MS Access
data files. You might have to convert Access data tables to Excel
spreadsheets (not hard) and then import the spreadsheet files into
OpenOffice.
How you would rebuild the relational aspects once in OpenOffice I don't
know. I'd be interested in hearing how that works, or if anyone as gotten
the OpenOffice database to read Access files directly.
Jim Shields
in Westfield, Indiana
USA
At 09:32 AM 9/19/2009 +1200, you wrote:
re OpenOffice I never realised there was a database in the OpenOffice.
Thanks Leo! Now to find my way around it. It has everything which
could possibly be wanted. Wonderful.
Ina Crossley
Jim Shields USDA Zone 5 Shields Gardens, Ltd.
P.O. Box 92 WWW: http://www.shieldsgardens.com/
Westfield, Indiana 46074, USA
Tel. ++1-317-867-3344 or toll-free 1-866-449-3344 in USA
_______________________________________________
pbs mailing list
pbs@lists.ibiblio.org
http://pacificbulbsociety.org/list.php
http://pacificbulbsociety.org/pbswiki/