Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Links / March 2004

Tip: Looking for answers? Try searching our database.

Outputting Form Data To Excel Spreadsheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Zara!!!! - 01 Mar 2004 15:20 GMT
-----------------------------------------------------------
---------------------

I have been given the task of creating a web survey form.
The form itself is going to be quite basic with name etc
and some radio buttons to enable users to choose a
particular option for a certain question.

The problem is that the data entered by the users needs to
be held in an excel spreadsheet so the data can be
reviewed and reported against.

I suppose in short my question is what is the easiest way
to get the data entered on the form by the user into an
excel spreadsheet?

All help much appreciated
Bill Manville - 01 Mar 2004 23:45 GMT
> I suppose in short my question is what is the easiest way
> to get the data entered on the form by the user into an
> excel spreadsheet?

I think I would have the server page write the data to a database
table.  I would then have Excel query that database table to retrieve
the information and do the reporting

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.