Excel To MySQL with MySQL Migration Toolkit

If we want to change excel file to mysql, we can change with MySQL Migration Toolkit that contain in MySQL GUI Tool.

 

1. Change .Excel file to MS Access. You can import excel file in MS Access.

2. Open MySQL Migration Toolkit and choose MS Access. You will do setp by step with wizard. It’s easy, don’t worry it.

3. You will see new database in mysql. Ok. Export only tables from phpmyadmin and then import the another database that you want to import.

 

It’s easy and you can do csv to mysql like that. You need to open csv with excel and save as xls. After that you can do from step 1.

 

Cheer!!!

 

comments powered byDisqus