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
Host with the leader in ColdFusion hosting.
Voted #1 ColdFusion host by CF Developers.
Offering shared and dedicated hosting options.
www.cfxhosting.com/default.cfm?redirect=10481
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
