Subject: Re: ms access,openoffice and mysql
schneider@ferocitydesign.com
Date: Sun Feb 02 2003 - 16:39:54 AKST
Mehran,
I've never been able to get mysql to directly import (file to file) a comma
delimited file cleanly before, 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...
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.
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.
This archive was generated by hypermail 2a23 : Sun Feb 02 2003 - 16:40:04 AKST