How do I import data from a XLS file into a mySQL database?
A:
If you have access to PHPMyAdmin, you should be able to save the data as CSV and then import that into MySQL.
Tim Coker
2010-07-06 14:15:35
Yep, that the one way. But had to do it dynamically through PHP. And i used phpexcelreader. thats the cool stuff...:)
Neeraj
2010-07-07 13:30:36
To help others out, you should post that as an answer with a link to the project and mark it as the accepted answer.
Tim Coker
2010-07-07 15:02:04