Step 1. Download Software From
Download Access To MySQL Product From
After Install this software follow this steps .
1) In the first step you are asked to supply the file name of the Microsoft Access Database to convert.
If your Access database requires you to log in you can specify a user name, password and a system database.
2)The destination database and MySQL server connection settings are specified as shown below. You will have the choice of placing the result in a dump file instead of transferring it directly to another MySQL database.
3)You can specify exactly which tables you want to transfer to the destination database. Just check the box in front of each table name you want to transfer and click next.
4)A You can also select not to transfer any records. This will only create the tables in the destination table and leave them empty.
In both Access and MySQL fields can have default values. When creating the tables in MySQL the program can preserve the default values specified in the Access field definition. Also auto number properties of a field can be transferred if you check the Auto number properties box.
The transfer will now run until all the selected tables are transferred. When the transfer is done you will see a small report telling you how much data was transferred.
EmoticonEmoticon