Subject: Re: ms access,openoffice and mysql
From: Shortpier (shortpier@shortpier.is-a-geek.com)
Date: Sun Feb 02 2003 - 12:20:19 AKST
Tim Johnson 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.
>>
>>
>
>
>
Hmmm I would always use ODBC to connect to the Mysql (or Postgress) and
then import the data useing querys from access.
Shortpier
10 Mins, Bill Gates, and a Baseball bat. Is this to much to ask God?
---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
This archive was generated by hypermail 2a23 : Sun Feb 02 2003 - 21:20:55 AKST