Solved

Posting Web page data to excel

Posted on 1997-05-09
2
161 Views
Last Modified: 2013-12-25
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.
0
Comment
Question by:mkwia
  • 2
2 Comments
 
LVL 4

Accepted Solution

by:
jshamlin earned 100 total points
ID: 1854176
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
 
LVL 4

Expert Comment

by:jshamlin
ID: 1854177
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

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn by example how to specify CSS selectors for Selenium WebDriver test automation software.
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question