To import data from Excel to MySQL phpmyadmin.

used software: phpMyAdmin 3.1.1 and MySQL 5.1

 Save your Excel data as a csv file (In Excel 2007/2003 using Save As)

1. Check the saved file using a text editor such as Notepad to see what it actually looks like, i.e. what delimiter was used ex. : ; , etc.
2. Goto localhost-phpmyadmin, select required database and create a table with column crediantials.
3. Select the table and select the import tab then browse file to import.
4. Select the format of imported file .csv file, goto fields terminated by change your delimited symbol example ; or , which ever on your data mostly select , symbol there.
5. Click on go button.
6. Thats all your data sheet will be imported into mysql database

Hope this my help.

Regards
Janardhan