How to deal with Form Data?

[mjmuk]

Hi,

I have designed a form to capture data from a web site and I use the http://www.thalasson.com mailform services to deliver the 'captured' form date to an email address.

My question is... How can I capture that form data into say an Excel spread sheet - does that mean I have to convert the form data to .csv. Or, should I try and 'convert' the form data somehow, on the web page to deliver it ready formated, or am I thinking too complicated! I suppose I could ask the same question if I wanted to get the form data into an Access database (or other database). I have ttied to find a resource on the web as to what to do next but so far have struck out. Anyone have any suggestions???

Mike
:confused:

[toicontien]

CSV should work fine. That's about as simple as it gets.

[mjmuk]

Okay understand that, but perhaps I'm not asking riight question! What tool(s) can I use to do the conversion to .CSV?

[toicontien]

You'll want to save the form data in a data base, the you can run DB queries to gather the info you want and use PHP to create a CSV file. This unfortunately doesn't fit well with the form-to-email script you currently have. You'd have to modify the current form to email script.

[mjmuk]

I don't have any DB (PHP) installed on the web site as its a very simple (light) web site with only a few sets of pages, is there any other way of doing this?

[toicontien]

You could alter the form to email script so it creates and saves a CSV file automatically. Then you can just download the CSV file.