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
