check out cfcomet.com
Doug >-----Original Message----- >From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] >Sent: Wednesday, June 04, 2003 4:00 PM >To: CF-Talk >Subject: Dynamic connection to an excel file. > > >Folks, > >On a CF 5 server I'd like to make a dynamic connection to an excel file >using the dynamic query option. I have 2 issues. First, I >can't seem to >get the connection string right. This one seems to access the file: > >Driver={Microsoft Excel Driver (*.xls)}; DBQ=d:\test.xls; FIL=MSExcel; >MaxBufferSize=2048; PageTimeout=5 > > >The call to the driver is returning an error FROM the odbc >"excel" driver >that says "installable ISAM could not be found". Does anyone have the >proper syntax for this? > >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! > >-Mark > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
