Survey form in SharePoint WSS 3.0

ummm.
why not use the built-in survey?

http://office.microsoft.com/en-us/windows-sharepoint-services-help/create-a-survey-HA010208578.aspx

I agree with Zephyr to use the built-in survey on SharePoint, unless you meant that one of your requirements is to have this survey pull or push data from an existing database?

I do have requirement to push and pull data using database.

do you mean you want to migrate data between database and sharepoint

there are many tools out there, its called ETL (extract, transfer and Load)

for Microsoft there is SSIS

http://www.sqlmag.com/article/database-administration/build-a-simple-etl-system-with-ssis.aspx

Thanks for your response. I need to build the Survey so users can take it on Sharepoint. Once they take the Survey, I need to get the data and display in reports to be sent by email.

So my confusion is where is this Survey data stored. Is it in Database in some table which I can access from outside of Sharepoint using some Reporting tools?

Please let me know.

Another thing is, users who take survey shouldn't know the answers posted by other users.
Can we do this in built in survey of sharepoint?

to answer your question about where the data is stored:
it depends on how you have it configured.  if you have it configured to save the data in sharepoint, then it will be in the sharepoint content db, and you can access it there for reporting.  my guess is that this is the way you'll want to configure it (save to sharepoint).

and yes, you can control security so that users can only see their own.

Zephyr,

Thanks for your response. Like I mentioned I am new in Sharepoint and I would appreciate if youcan tell me how we can control security, so that users can only see their own response.

thanks

This works. Thanks for guiding me towards a right solution.

thanks