Forms

Hi Victoria,

Normally you would use a server side scripting (ASP, PHP, .NET, CGI) language and put the data straight into a database on your web server (MySQL, MSSQL, Access).

I would skip the Excel part out all together, unless you mean a CSV (comma separated value) file, which Excel can interpret and put into columns.

Currently, the .ATT file contains the results from your web form. This will be an ASCII text file with a bunch of strange characters betwee the data fields. You should be able to use the Import Wizard in Excel to bring the data fields into an Excel worksheet. The format is similar to a .CSV file so try renaming the .ATT file to .CSV file and open the file in Excel to see what you get.

If you haven't got time to learn a server side scripting language, there are free services out there that can do this for you, like Bravenet: http://www.bravenet.com/webtools/emailfwd/

Using server side scripting programming, you will also be able to tell when a question has not been answered (eg. your tick boxes).

If you require consultancy (where our trainers come in and do a lot of the work for you) please contact the enquiries team for more information.

I hope this helps, Victoria. If you have any follow up questions I'd be happy to help.

Kind regards, Rich