Hi there
I am succesfully using DB Tools, you can find it on the MYSQL web site. It
works perfectly, you just need to change your date columns, as when it
imports, it imports as a DateTime (because that is how access works), and I
wanted Date only columns.
Otherwise works like a dream
Cheerio
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> ]On Behalf
> Of Ute Hoffmann
> Sent: 07 June 2001 12:22
> 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
