Posting Web page data to excel

I am looking for a way to post data from a web page form directly to an excel spread sheet. I am using IIS 3.0 and MS FrontPage. An example would be appreciated.
mkwiaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jshamlinCommented:
You're going to need your ISP's help to do this.  A database file is no more functional than an Excel spreadsheeet without the server process to drive it (and parameters set on the server side to process the database as a database rather than a flat file).

Then, you'll need to use NotePad or another text editor to write .idc files ("internet database connector" - contains the SQL statements necessary to put the data in the database and do whatever error-trapping you'd like to do) and, if necessary, .htx template files to catch output from .idc files.

If this is confusing, then you may need to hire help - setting up a WWW-based database is a tricky matter that isn't "do-it-yourself" for most people.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jshamlinCommented:
Doh!  Some factual errors - I was thinking MS Access rather than MS excel.  It's not a databse thing, but a CGI script thing.  Slightly less complex, much less functional, but still requires programming that FrontPage won't happen.

Basically, you'll need a CGI script to parse the file, find the location(s) into which to insert the data, and insert it in the proper format.

But I don't suggest that ... stick it into an ASCKEY delimited text file instead.  If the syntax is correct, Excel will convert that text file into a spreadsheet.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.