Actually, you could build a VBA macro that utilizes WDDX. That way you
could simply run the macro from a normal spreadsheet and have it post to
a website (without having to build a "web" interface) Take a look at
wddx.org's sdk.
--
Billy Cravens
[EMAIL PROTECTED]
Eric Dawson wrote:
>
> 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
