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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
