Design advice in a scenario where MsExcel interacts with MySQL

[marisha]

The Background

---------------------

1) The vendor will submit his excel sheet on website and the whole data will get imported in the MySql

 

2) The amount of data that we are going to receive in excel sheet will be like 9 - 10 columns , with macros and inbuilt functions and atleast 60 rows.

3) We are going to receive 10 - 15 excel sheet per month. We rely on these data for reporting.

 

My thought process

--------------------------

My database is MySql , I am using Php for server side form handling. I have never designed a system in Php to handle MsExcel. I have experience in designing such website in .Net both being Microsoft product have alot of compatiility.

 

 

Can the gurus suggest me any online tutorial I can refer or the way I should approcah it.

 

 

 

Thanks

Marisha

[Lautarox]

If I'm not mistaken, Excel files can be saved in a XML readable way, the user should save his file in that format and once he uploads it you can parse the file using the xml functions from php.

[possien]

There are some API's and classes that will provide an ODBC connection to excel.  You could then query the data into an update to append the data.  A script could be written to upload the file, connect with odbc, update sql, and store the file for each time a file is uploaded. Search for "php excel api" and you may get some ideas.