AllExperts > Experts 
Search      

Active Server Pages Programming (ASP)

Volunteer
Answers to thousands of questions
 Home · More Questions · Answer Library  · Encyclopedia ·
More Active Server Pages Programming (ASP) Answers
Question Library

Ask a question about Active Server Pages Programming (ASP)
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Srini Nagarajan
Expertise
I can answer any kind of questions in ASP.NET, C#, VB.NET, SharePoint 2007, ASP, Coldfusion, Powerbuilder 7.00 / 8.00, JAVA servlets, MS SQL 2000 / MSSQL7, Sybase

Experience
Contact me if you need any custom development on ASP.NET, ASP, SharePoint 2007, Coldfusion, Powerbuilder.
 
   

You are here:  Experts > Computing/Technology > Business Software > Active Server Pages Programming (ASP) > ASP Form

Topic: Active Server Pages Programming (ASP)



Expert: Srini Nagarajan
Date: 3/11/2008
Subject: ASP Form

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

Add to this Answer    Ask a Question



  Rate this Answer
   Was this answer helpful?
Not at allDefinitely              
   12345  

     
About Us | Advertise on This Site | User Agreement | Privacy Policy | Help
Copyright  © 2008 About, Inc. About and About.com are registered trademarks of About, Inc. The About logo is a trademark of About, Inc. All rights reserved.