Cannot transfer from Access to MySQL

Installation and setup related issues.

Moderator: jr

Post Reply
gene_az
Posts: 1
Joined: Thu Nov 13, 2008 1:11 am

Cannot transfer from Access to MySQL

Post by gene_az »

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
Post Reply