If you are familiar with perl, try using DBD::ODBC module to pull
the data out of Access and use the DBD mysql modules to write the
data to mysql. You will have to set up the table structure in
mysql to match your Access.
-----Original Message-----
From: Ute Hoffmann [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 07, 2001 12:22 PM
To: [EMAIL PROTECTED]
Subject: Access Database into mysql
Hi,
I have a database table, which was made with Microsoft Access and
am to move
the data into a mysql database table. As there are some long
entries, which
exceed the data size allowed in a table cell by Microsoft Excel I
can't
export it via Excel and convert it from Excel into a Text Tabs
document (As
I did with other tables).
I tried all possible export options with Access, but when I try
to do a text
document it just removes all data, which is not visible on the
monitor, when
the export takes place. (It is a table with many columns). I can
have either
a html file or a richtext file with all the data in. Both seem to
me not
that useful for my purpose.
Is it possible to export the data directly from Access to Mysql
via the ODBC
Adaptor? If so, how?
Is there another way to get the data from Access to Mysql without
the need
of either pasting them in per hand or by putting the tabs and
breaks in by
hand into the rich text file to end up with a text which is tabs
separated
and can be imported?
I work on a NT machine. The data will be exported to mysql and
will then be
moved to a MacOsX Server 1.2.
Thank you for any suggestions, as doing it by hand will be very
inconvenient.
sincerely
Ute
_________________________________________________________________
________
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
-----------------------------------------------------------------
----
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
<[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
