that's an excel web query. From Excel. Menu.Data.Get
ExternalData.NewWebQuery
Here's what I want to do.
I have a web site (not mine) and I have 1200 individual items I want to post
to a web database. This is normally done using a clumsy web form. But I want
to create an excel spreadsheet that can post data from the spreadsheet to
the web site.
Not sure how to build the HTML in excel to be able to post. Basically I want
to have a submit button beside each record in excel.
No problems once I have the form generated. The website doesn't check where
the post comes from.
Has anyone done this? Excel would be a pretty flexible tool to create some
quick web database interfaces.
Eric
From: "Eric Dawson" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: Excel and CF
Date: Thu, 04 Jan 2001 08:39:54 -0600
OT but not OT.
I have been using web queries lately. simply specify an "ID=somename"
attribute in the <table > and use web query to specifically pull that table
into excel. pretty slick and quick to do.
I can forward a simple example if you like.
Eric
From: "DeVoil, Nick" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: Excel and CF
Date: Thu, 04 Jan 2001 12:16:15 -0000
Does the client want to view the data over the web or just in-house?
If the latter, you don't need any CFX tags, MS Office lets you do this
easily within Excel.
-----Original Message-----
From: James Maltby [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 04, 2001 12:09 PM
To: CF-Talk
Subject: Excel and CF
Does anyone have advise of providing excel spreadsheet output/extraction
from an Access database? Website will send collected data into access
database and then client requires data to be viewable in an excel format...
any ideas cfx tags etc?
James
"You're a big man, but you're out of shape. With me it's a full time job.
Now behave yourself."
"Get Carter" 1964
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
