What difference does it make whether Oracle is supported or not? The choice belongs to each individual as to what back end they want to use and why when LO is used as the front end. What matters most is whether a program works well or not.
--Dan On Thu, 2012-04-05 at 12:52 +0100, Tom Davies wrote: > Hi :) > MariaDb could presumably be used instead of MySql or is it important to > support Oracle? > Regards from > Tom :) > > > --- On Thu, 5/4/12, Dan Lewis <[email protected]> wrote: > > From: Dan Lewis <[email protected]> > Subject: Re: [libreoffice-users] libre office and microsoft office access > To: [email protected] > Date: Thursday, 5 April, 2012, 12:33 > > On Thu, 2012-04-05 at 09:13 +0100, Tony Sumner wrote: > > On Apr 05, 2012, Mark wrote: > > > > > > > > > One method is to find a decent back end such as MySQL and move > > > your table across, while temporarily maintaining your front end in > > > Access. MySQL has a migration assistant which may help here. > > > > I have developed a scheme for migrating an Access database to MySQL. > > Briefly > > 1. mdb-export generates a CSV file > > 2. run a program to convert this into a shell script consisting of > > a set of 'insert into' statements > > 3. run this in MySQL > > There are some small details on the way. I can post the script and program > > if you think it would be helpful > > > > Tony > > MySQL uses the command LOAD DATA to insert data from a text file. > It must be tab deliminated and have \n for each null value. Can this be > done with what you are describing? > > --Dan > > > -- > For unsubscribe instructions e-mail to: [email protected] > 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: [email protected] 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
