Intelligent Converters has a product that's pretty inexpensive, about $35 I believe. It pretty much works as advertised, it was much cheaper than spending any time trying to roll my own script.
We recently got an Excel spreadsheet that we needed to import, and after a few minutes of playing around trying to import it, I just bought their Excel-to-MySQL program. Including the time it took to buy the software, it took less than 15 minutes to import. The hardest part was finding their website, www.convert-in.com Tac ----- Original Message ----- From: "Greg Knaddison" <[EMAIL PROTECTED]> To: "Ivo Dvorak" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, October 14, 2002 11:34 AM Subject: RE: Export of text fields from Access2000 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 --------------------------------------------------------------------- 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