If you create the tables beforehand in MySQL and then export the data into the already created table, that should allow you finer control of your data types. To save time you could export the table from Access, then truncate it to clear out the data, and then change the data types as necessary.
I don't have experience with your scenario specifically, but I have had similar problems with Excel, Access, SQLServer, and Oracle. Data types between applications are a big problem and in some of my problems I found Microsoft Knowledge Base articles stating "this is a known bug, we're not going to do anything about it." See Troubleshooting in Microsoft KB article Q321686. Greg -----Original Message----- From: Ivo Dvorak [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 6:18 AM To: [EMAIL PROTECTED] Subject: Export of text fields from Access2000 Hello, I export a table from Access 2000 on WinXP to MySQL using the MyODBC 3.51.04 and text fields are exported as text fields from Access instaed of varchar as it should logically be (MEMO is the Access equivalent for Mysql text type). I have Jet SP6 and latest MDAC installed. Is there a workaround from this? PLEASE send message to [EMAIL PROTECTED] if you know what to do. Thanks. Ivo --------------------------------------------------------------------- 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
