hi
i was trying out this dumping of data into spreadsheet.
Does it still work when the whole application is tied by session ? i tried
but it gives me an error stating
cannot open page. But when i tried it on the web browser, it can display the dynamic
data. Any other way out?
-----Original Message-----
From: Kola Oyedeji [mailto:kola.oyedeji@;iclployalty.com]
Sent: Wednesday, November 06, 2002 5:12 PM
To: CF-Talk
Subject: RE: Dump a SQL table into an Excel spreadsheet
Liz
Wow. Thanks for that. Looks like we've been re-inventing the wheel!
Kola
>> -----Original Message-----
>> From: Les Mizzell [mailto:lesmizz@;bellsouth.net]
>> Sent: 05 November 2002 17:51
>> To: CF-Talk
>> Subject: RE: Dump a SQL table into an Excel spreadsheet
>>
>> :> What exactly are Excel web queries? I've heard Its an alternative
but
>> :> That's about all I know about it.
>>
>>
>> 1. Open Excel (I'm using Office 2000 here....)
>> 2. On the "data" menu and select "Get External Data"
>> 3. Click "New Web Query"
>> 4. Enter the address of the page that generates the data:
>> http://www.mySite.com/EXCELGen.cfm
>>
>> Excel grabs the data from the page and automatically pops it right
into a
>> spreadsheet. Easy as pie.
>>
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
