Re: [libreoffice-users] libre office and microsoft office access

     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 <elderdanlewis@gmail.com> wrote:
>
> From: Dan Lewis <elderdanlewis@gmail.com>
> Subject: Re: [libreoffice-users] libre office and microsoft office access
> To: users@global.libreoffice.org
> 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: users+help@global.libreoffice.org
> 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: users+help@global.libreoffice.org
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