With Word, if I am not mistaken, you can just do file - open then in the file dialog type in http://whatever.com/whatever.cfm
-----Original Message----- From: Rick Faircloth [mailto:Rick@;GoLibertyOnline.com] Sent: Tuesday, November 05, 2002 10:30 AM To: CF-Talk Subject: RE: Dump a SQL table into an Excel spreadsheet I've been trying to get Word documents to "automatically grad" data like that, too. Would the same procedure work for Word docs? Rick -----Original Message----- From: Les Mizzell [mailto:lesmizz@;bellsouth.net] Sent: Tuesday, November 05, 2002 12:51 PM 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
