Subject: Re: ms access,openoffice and mysql
From: Mehran (cf680@yahoo.com)
Date: Mon Feb 03 2003 - 06:48:07 AKST
Tim;
I am still working on it. I've saved Excel file as
.cvs and import them to a text editor, it works , but
its very time consuming.
--- Tim Johnson <tim@johnsons-web.com> wrote:
>
> * schneider@ferocitydesign.com
> <schneider@ferocitydesign.com> [030202 16:54]:
> >
> > Mehran,
> >
> > I've never been able to get mysql to directly
> import (file to file) a comma
> > delimited file cleanly before,
>
> Yep. Sounds daunting alright. I've emailed Mehran
> to tell him that I
> have written VBA modules to export Access Tables to
> tab delimited files
> with (hopefully) proper 'escapes' that are
> something compatable
> with MySQL.
>
> I don't mind sharing them, as I wrote them
> specifically for a client's
> needs and I wouldn't mind seeing if they worked for
> someone else's needs.
>
> I 'mcguyver'd some example stuff that I found
> through the MySQL site.
>
> > so I generally mcguyver it to get the format
> > proper. It involves using the inherent msaccess
> export utility to save
> > your data as .csv files. I create my CREATE TABLE
> syntax in a separate
> > file and import to mysql using, gasp, copy and
> paste...
>
> My process works well with 'load local infile' but
> not all server admins
> like to allow that, so I build tables on my own
> machine and run
> mysqldump to create .sql scripts which can then
> create/recreate a
> remote mysql database.
> <sigh>I with all my clients would just use Linux.
> It would make
> life easier for me </sigh>
>
> > If anyone has been able to use mysql's import
> process from a file
> > successfully, please enlighten us. My way,
> however, does work like a charm.
>
> And it's what works that counts. :-)
> -tim-
>
> >
> > Kate
> >
> >
> > At 05:03 AM 1/31/2003 -0800, Mehran wrote:
> > >
> > >Hi;
> > >I have bunch of files in ms access format. I
> would
> > >like to be able to open them with open office (no
> such
> > >luck yet). Although open office gives me the
> option of
> > >choosing a file format I haven't been able to
> open any
> > >.xls files yet. But the major goal is to convert
> all
> > >my .xls files to mysql. I saved few .xls files as
> > >text(delimited)files to import to mysql, but
> dosen't
> > >work very good. Any help is appreciated
> > >cheers
> > >mehran
> > >
> >
> >__________________________________________________
> > >Do you Yahoo!?
> > >Yahoo! Mail Plus - Powerful. Affordable. Sign up
> now.
> > >http://mailplus.yahoo.com
> > >
> > >---------
> > >To unsubscribe, send email to
> <aklug-request@aklug.org>
> > >with 'unsubscribe' in the message body.
> > >
> >
> >
> > ---------
> > To unsubscribe, send email to
> <aklug-request@aklug.org>
> > with 'unsubscribe' in the message body.
>
> --
> Tim Johnson <tim@johnsons-web.com>
> http://www.alaska-internet-solutions.com
> http://www.johnsons-web.com
>
> ---------
> To unsubscribe, send email to
> <aklug-request@aklug.org>
> with 'unsubscribe' in the message body.
>
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
This archive was generated by hypermail 2a23 : Mon Feb 03 2003 - 06:48:28 AKST