Cannot transfer from Access to MySQL
Posted: Thu Nov 13, 2008 1:23 am
New to MySQL. I have just installed MySQL (6.0) on Win Vista 64-bit machine, ODBC Connector (5.1), Bullzip (3.x), MySQL GUI (5.0), MySQL Workbench (5.0) and DreamCoder. Setup of MySQL seemed successful (localhost using root). In trying to use Bullzip to copy a table from an Access database, I get the following error:
- Error: -2147217900 (80040E14) [MySQL][ODBC 5.1 Driver][mysqld-6.0.7-alpha-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB DEFAULT CHARSET=utf8' at line 1
- 0 records moved
Tried switching back to ODBC 3.x, reinstall, etc - nothing seems to work. Do you have any suggestions?
Thx. Gene
- Error: -2147217900 (80040E14) [MySQL][ODBC 5.1 Driver][mysqld-6.0.7-alpha-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB DEFAULT CHARSET=utf8' at line 1
- 0 records moved
Tried switching back to ODBC 3.x, reinstall, etc - nothing seems to work. Do you have any suggestions?
Thx. Gene