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
