how can i convert access database to mysql database

i have access database contains about 36000 rows

every time i try to convert it using mysql migration toolkit i get only about 5000 rows

is there any better free program to use or any way to fix this ?

 

How complicated is the access database. Many times, the easiest way it to export it as text files and then import those into mysql.

 

Have you tried Bullzip? http://www.bullzip.com/products/a2s/info.php

The best program according to me is ESF Database Convert, but its not free.

 

You have one? Is there a place it can be viewed?

 

CSV export from Access and import into MySql

Also remember that ACCESS does allot of things other databases frown upon, Also some data types like GUIDs dont exist in mysql

 

True, but unfortunately Access has a 2gb limit and requires Windows hosting platforms if you wish to take it online.