Dude, Never mind... I found the answer on CF Comet. I needed a dollar sign after my worksheet name. Thanks for your help!
-Mark -----Original Message----- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 3:53 PM To: CF-Talk Subject: RE: Dynamic connection to an excel file. Dude, How do I define a "named excel range"? -mk -----Original Message----- From: CF Dude [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 3:10 PM To: CF-Talk Subject: Re: Dynamic connection to an excel file. I forgot about this question >Secondly, once I connect successfully - what do I use to query with? Is it "sheet1" or workbook1.sheet1 or ... what? Any clues are helpful. Thanks! When I'm connecting from ASP I just run queries like it's a sql table. where table = Excel Named range Eric ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4