how to import excel data into mysql

[eluser]chellam[/eluser]
how to import excel data into mysql

[eluser]rogierb[/eluser]
Since you explained your problem so extensively I would do the same with the answer:
1: convert to csv
2: import with phpmyadmin

[eluser]chellam[/eluser]
how to convert xls to csv

[eluser]überfuzz[/eluser]
Use your spreadsheet client. Save as csv.

[eluser]chellam[/eluser]
thank you.....