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

Not if you're using a Mac.

On Thu, Apr 5, 2012 at 7:52 AM, Tom Davies <tomdavies04@yahoo.co.uk> 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

-- 
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