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 MySql 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.
Hi, although I'm new, I'm more than capable to deliver your requirement quickly with very reasonable price. I've done similar thing in my company previously.
$30 USD en 1 día
5,0 (3 comentarios)
3,0
3,0
20 freelancers están ofertando un promedio de $100 USD por este trabajo
##########################################################################################################################
DEAR SIR, I HAVE DONE THIS BEFORE. MANY THANKS...
###########################################################################################################
It has a simple solution based on your server (commercial shared hosts will). have some restrictions). Details in PMB. I have been working on LAMP based solutions for over 10 years. We have a 100% project completion rate with excellent client feedback over 16 projects. Regards, Arijit