Access vs MySQL - Transferring your Access data to MySQL through Navicat
(Page 4 of 5 )
Navicat supports imports from various file formats such as text file, csv file, xml file, excel file, access file, html file and some more.
To import Access data to MySQL, get a 30-day free trial of Navicat from http://www.navicat.com/download.php3.
Inside Navicat, there is an Import Wizard. In the table view, click the icon Import Wizard.
In step 1 of the Import Wizard, specify the file type you would like to import. In this case, we choose MS Access database .mdb file. Click Next to proceed.
In step 2 of the Import Wizard, choose the location of the access file. Once you have chosen the location of the file, all your tables in your access files will be shown in the Table name box. Choose the tables which you would like to import. In this case only one table is present, but in reality you may have more than one table to import.
The import wizard will skip steps 3-5 and jumped to Step 6. In this step, you can manually change the data type of the field. The value shown is the automatically generated type detected by the system.
The import wizard will skip Step 7-9 and jump to Step 10. Choose Append: add records to the destination table and click Execute to start the conversion process. With the help of Navicat, the conversion process becomes unexpectedly easy. You can finish all of the process within one minute!
Navicat not only helps you importing the Access data into MySQL, but also contains functions which Access has and more. Using MySQL with Navicat works like what you usually do with Access, but making your database more powerful than ever.
Next: Conclusion >>
More Database Articles Articles
More By Codewalkers
