I have done something very similar. The easiest way (ie if you just want something to work very quickly) is to set up a CGI script to write the data for each record on one text line, delimited by semi-colons or similar. This will allow you to import it into Excel with the columns set up automatically.

The data in the file will be not too easy for humans to read, but Excel will love it:

NAME1;ADDRESS1;DATE1;OTHER STUFF1
NAME2;ADDRESS2;DATE2;OTHER STUFF2
....

Remember to add some lock mechanism so that only one write action can be carried out at one time. I suggest creating a lock file during write and then delete it when you are done. This is the stupid mans way of doing it, but is very quick and easy. There may be a problem with storing it this way when you have large numbers of records coming in, but will probably be ok for what you want.

I'll post some code to help you if I can find it again.

Good luck.

Andrew.

In reply to Re: Web form -- File by murphya
in thread Web form -- File by Anonymous Monk

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.