Here's what I'm looking to do, I need to create a web page allowing a user to upload a zip file to my web server (linux) containing 5-10 excel files then unzip and insert the excel files into our mysql db. Each excel file will be labeled with the corresponding table name and the 1st line in each excel file will have the field names also matching the field names in the table. I know how to upload a single excel and insert it but I'm running out of time to to figure out the zip/multiple insert. Has anyone done this before? Seems simple for an advance programmer and I wished I had the time to figure it out but I'm willing to pay a reasonable fee if you have the script. Any help would be much appreciated!! BTW can switch excel files to csv if helps.
the best and faster way of doing this is by transferring the uploaded excel archived files to your servers file system. ive done this with images. and believe me the end results are not that good in performance both in database and in the frontend.