Importing MS Excel Data into a MySQL database using PHP

[starrylitgal]

I m new to PHP programming.

Can ne1 help me in converting/extracting data from an Excel database into a MySql database using PHP?

 

I am creating a web portal where the admin will upload data into the database using these excel sheets wich has the data.

I want to know how to do this using PHP scripts automatically at the backend---extracting data from the excel sheets into the appropriate MySQL tables?

 

i hav found tools/softwares for doing this job...but i want this to happen in my website using PHP?

 

Does ne1 know how to do this using PHP???

Does ne 1 hav PHP scripts fr doing this?

 

Plzz help coz its urgent! This is a part of my collg project and i m wrking on  deadline basis.

 

Helpp!! ???

 

[Mark Baker]

i hav found tools/softwares for doing this job...but i want this to happen in my website using PHP?

What tools/softwares have you found?

Any answer that we might give is dependent on the tools you plan to use

[starrylitgal]

I don't plan to use any of these tools. These tools are standalone applications which take the excel workbooks as input and import data into the MySQL database.

 

I want the same functionality in my website as one of my features but using PHP rather than using any wizards. The webiste will take an excel shet as an input and import all the data into the database. Admin of the site is responsible for doing this.

 

I mentioned these tools jus bcoz whn i tried searching for PHP scripts for this purpose i cud only find such tools.

 

Where can i get the PHP script for implementing this functionality or does anyone hav any idea of how to go abt this problem?

 

I am a naive programmer in PHP so help will truely appreciated 

Please help!!

 

Thanks in advance!