To start using MySQL, a good planning is important as there is some incompatibility between MS Access and MySQL. To transfer the data successfully, there a few points we have consider. One of the important data incompatibilities we must consider is the column type and data format. Although most of the column types in MS Access and MySQL are compatible with each other, the capacity of specific column type may differ.Transferring your MS Access data to MySQL through Navicat.
For more help please visit the following link:
http://www.techyv.com/questions/how-convert-access-database-mysql-50