We help IT Professionals succeed at work.

Posting Web page data to excel

mkwia
mkwia asked
on
Medium Priority
196 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.
Comment
Watch Question

Commented:
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Commented:
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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.