How to export data from an Excel Spreadsheet to database, using PHP

[sammy111]

Hi,
I have a query regarding how to export data from an excel spreadsheet to a mysql database, by using PHP.
I have created the upload form functionality, which enables the excel spreadsheet to be uploaded on to my webserver.
But from there on I am confused as to how I can start getting the data extracted from the excel spreadsheet and in to a mysql database table.

Any help and suggestion would be extremely appreciated.
Regards,
Sammy.

[jatar_k]

I would suggest using CSV format and try this thread from our Library [webmasterworld.com]

Basics of extracting data from CSV files [webmasterworld.com]