You should be able to export data directly from Access to a delimited text
file.
Curtis
On Thu, 7 Jun 2001, Ute Hoffmann wrote:
> 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
