I connect to .xls files from asp from time to time, and here is the connect string
that I use
"DBQ=c:\dir\file.xls;DRIVER={Microsoft Excel Driver (*.xls)};"
As far as the ISAM driver error, I'd just double check that you're running the latest
MDAC (if that applies here)
E
----- Original Message -----
From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>
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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
