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