Upload zip file with excel files to mysql
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? <snip> Any help would be much appreciated!!
BTW can switch excel files to csv if helps.