Not if you're using a Mac. On Thu, Apr 5, 2012 at 7:52 AM, Tom Davies <[email protected]> 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 > > -- 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
