SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Threaded View

  1. #1
    SitePoint Member
    Join Date
    Jan 2012
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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.
    Last edited by Shyflower; Mar 12, 2012 at 10:14.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •