Dwayne, I've had good success with the Intelligent Converters products. Here's the Access-to-MySQL one:
http://www.convert-in.com/acc2sql.htm They do a (mostly) good job on converting the datatypes and table constraints. I've migrated several decent-sized Unicode databases this way and have never had any issues with special characters either. Some of that may also be influenced by the default encoding you specify for the database in MySQL. HTH, Jon On May 7, 2007, at 2:02 PM, Dwayne Cole wrote: > Navicat. Well I have navicat and I can't find functionality that > let's you import from Access. Any other solutions? > > > ---------- Original Message ---------------------------------- > From: Will Tomlinson <[EMAIL PROTECTED]> > Reply-To: [email protected] > Date: Sat, 05 May 2007 00:56:31 -0400 > >> >>> I am trying to migrate access tables to MySQL using the MySQL >>> Toolkit. >>> However, it coughs up every time each reaches a field that >>> contains ' >>> & </ and other special characters. Are there any other tools >>> that can >>> move the data from access to mySQL without skipping the tables that >>> contains fields with such special characters. >> >> you could try navicat. navicat.com free trial >> >> Will >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277185 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
