How to Transfer Data from Microsoft Excel file to MySQL With xampp-win32-1.7.0
1. Create your data in Excel
2. Open Microsoft Access,create new file.Click File menu,sub menu Get external data and choose
Import.
3. After that you can Export the file to text type (*.txt)
4. Now Start your Apache Friend.
5. Open your browser and tpye http://localhost
and click the phpmyadmin sub menu.
6. Create Database.
7. Create New table.(adjust your record number with your Excel file)
8. After you finish create new table then choose Import menu
9. Click Choosen file and choose your .txt file that you create before.
10.Type of Imported data file that you will choose,in this case choose CSV.
11.In the 'Fields terminates by' option,type ','
