[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
> > > > >> -----Original Message----- >> From: list-bounces@xxxxxxxxxxxxx >> [mailto:list-bounces@xxxxxxxxxxxxx] On Behalf Of Tony Sumner >> Sent: 21 November 2006 12:45 >> To: list@xxxxxxxxxxxxx >> Subject: [LUG] OOo database >> >> >> My son-in-law runs a vet practice and he was complaining about the >> cost of upgrading MS Office. I suggested he might switch to OOo but is >> this going to work? He does use Access and OOo 2.0 (I haven't looked >> at 2.0.4) seems to import only from Word, Excel and Powerpoint. Has >> anyone tried a conversion by building a new set of tables and >> importing the content in CSV format or something like that? I am >> familiar with the Oracle DBMS and SQL but I have no great familiarity >> with Access. I recall seeing a post a little while ago saying that OOo >> is weak in this area; am I going to run into difficulties trying to >> work with OOo Base? >> >> Tony Sumner >> > > Getting the data should not be too difficult > In OOo create a datasource using ODBC (hopefully an access ODBC driver > is loaded) > Then just import tables /queries from OOo > > No chance with forms/VBA (though IMO these suck anyway) > > You should then be able to recreate DB in Base without too much trouble Or do it properly and export the Access data to a MySQL (or similar) database... there is a MySQL ODBC driver available (http://www.mysql.com/products/connector/odbc/) should you need it. -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html