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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
