Expert: Srini Nagarajan - 3/11/2008

Question
Hi, I was wondering if you could help me. I'm looking to create a web form so that when the user fills it out it will save to an excel document.
I found code online that creates a new excel document every time it is filled out, however I want to create it so that every time someone new fills out the form it will add a new entry to one excel document rather than creating a new one every time. Please help!

Answer
Hi,

Working with excel will be complicated, why don't you use Access database?  Since excel can't handle multi user access same time. If two people try to save same time file may create corrupt. where in Access it created new entry everytime you insert a new filled form.

When user wants' to download you can extract all the data into excel directly.

If Access is not possible try to use XML file rather excel.  

-Srini