On Sun, 23 Oct 2005 00:21, John Layt wrote: > Refer to http://dba.openoffice.org/drivers/mdb/ for full details, but you > need to install mdbtools first, there's a rpm in contrib, but I'm not sure > if it has the required patch on it. > > Then it appears you my or may not need to install the ooo driver, I don't > know if its included in the default ooo2 build, that page only seems to > refer to manually adding it to ooo1.1. > > John.
Well, using the ooo2 from contrib, I googled for the Northwind sample mdb file, installed mdbtools from contrib, selected File / New / Database / Connect To An Existing Database / Microsoft Access then selected the mdb. Ooo then proceeded to import the data into a new ooo format database. So hey, it works, but only for importing Tables, the Queries, Forms and Reports are not converted. In fact, I un-installed mdbtools, and it still worked, so the Mandriva ooo build in contrib must have it built-in (it doesn't appear to be part of the standard official build). However, there's also a package called mdbtools-gui in contrib which allows you to browse an mdb file without importing/converting it and will at least show you what Queries/Forms/Reports it contains, if not what they are. See http://mdbtools.sourceforge.net/ for details on what mdbtools supports. Other programs using mdbtools are Knoda, Rekall, and Kexi so it's good to have it installed anyway. John. Send instant messages to your online friends http://au.messenger.yahoo.com
____________________________________________________ Want to buy your Pack or Services from Mandriva? Go to http://store.mandriva.com Join the Club : http://www.mandrivaclub.com ____________________________________________________
