Solved

Posting Web page data to excel

Posted on 1997-05-09
2
158 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

895 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now