export form data to excel on submit

[LuigiX]

Hi

I have an asp form that is emailed. On submitting the form I want to also export selected data from the form to an excel spreadsheet where they will be appended as a new record to the spreadsheet. In this way the spreadsheet acts as an audit file and log.

The spreadsheet is slowly built up over time each time the form is emailed.

Does anyone have any code or examples of something like this they could direct me to?

Cheers

Luigi

[PeOfEo]

it would be better if you used an access data base table for this. Access is designed to be updated by scripts, excel is not, and excel is a little harder to use for this. If you just want a log, a list of records and nothing more, you could also append a text file. That way to view it you can do it from your browser, you would not have to download the file.

[LuigiX]

Hi P

Thanks for the advice.

Can you point me to an example of a readonly text file being updated from an asp page?

Cheers

Luigi

[PeOfEo]

'read only'? You mean properties -> read only?
http://www.freevbcode.com/ShowCode.asp?ID=89
http://www.learnasp.com/learn/txtwrite.asp
http://www.devasp.com/samples/writetofile.asp
http://support.microsoft.com/default.aspx?scid=kb;en-us;q300982
got those with this
http://www.google.com/search?hl=en&lr=&ie=UTF-8&oe=UTF-8&safe=off&q=asp+write+text+file&btnG=Search
Hopefully atleast one of those will work for you.