I was wondering if anyone would know what direction to go with this.
Here at work we have a form that is used by the schools to fill out each year when we have our earthquake week. The form was designed in Dreamweaver. When the folks fill this out they email the information back to us. Many schools participate in this.
Each year this comes back in a long straight line of data content, and the person responsible for the data has to hand put the information into an excel spreadsheet. We receive about 300 emails from various schools who participated.
Question..is there any code that we can use to program the emails to come back in a database. The webpage was designed in Dreamweaver and the code was asp.
Thanks...
First I would recommend switching to PHP to make life easy. Second I would delete the email form and replace it with a form that sends the data to ASP/PHP where it is processed and placed in the MSSQL/MySQL Database.
Skip the whole "form -> email -> enter data" part and just have it "form -> database". A good php programmer could do it in an hour or two.
If you are a programmer then I would look up tutorials on processing forms with php.
Once the data is inserted into a database you can just have it print out CSV/XML files whenever you need the data in a Excel format.
