Many sound points.

With CGI.pm you can upload a file quite easily. Over a LAN it will be reasonably quick. As people have pointed out exporting Excel to another format and zipping the file will make the post go even faster.

Once you have the file on the server you can decompress it and stick it into mySQL. Using the suggested modules.

Given that an Excel file may take a while to upload, extract and store in mySQL, I'd also suggest copious logging, so you can track down what's going on if people complain. As monks have mentioned you need to give positive feedback to the broser asap, to prevent multiple submits and user frustration.

To avoid multi-click behaviour of users, merlyn has a recent WebTechniques article about one click processing, which is well worth reading, even if you don't use it in this project.

In reply to Re: Uploading Excel data into MySQL via a browser by ajt
in thread Uploading Excel data into MySQL via a browser by La12

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.