Wednesday 18 June 2014

Export MS Access to MySQL with SnapShots

Create a Database in Ms Access
Open Microsoft Access and Create/Open a database which you want to export.
Create a Database in Ms Access




Export Ms Access Table into Excel Format
After opening the database, create a table and populate the fields which you want to insert into mysql database

Export Ms Access Table into Excel Format


Import Excel File into MySql Database
Open the database in Mysql and click on export button. Select the excel file and select option export ms access to mysql  and click on Go Button
Import Excel File into MySql Database