[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 170
  • Last Modified:

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.
0
mkwia
Asked:
mkwia
  • 2
1 Solution
 
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
 
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now