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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4