Excel ODBC:
ConnectionString="Driver={Microsoft Excel Driver (*.xls)};
DriverId=790;
Dbq=c:\somepath\mySpreadsheet.xls;
"DefaultDir=c:\somepath;"
Excel OLEDB via MS Jet
ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=c:\somepath\myExcelSpreadsheet.xls;
Extended Properties=""Excel 8.0;HDR=Yes;"";"
-----Original Message-----
From: Joseph DeVore [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 4:33 PM
To: CF-Talk
Subject: RE: XLS as a DSNless Connection
If you are running CFAS 5.0:
<cfquery name= "q"
dbtype="dynamic"
connectstring="DRIVER={SQL SERVER};SERVER=;UID=;PWD=;DATABASE="
blockfactor="100">
...
</cfquery>
FYI: Connect string properties are specific to the database you are
connecting to
HTH,
Joseph DeVore
VeloxWeb Technologies
-----Original Message-----
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 1:17 PM
To: CF-Talk
Subject: XLS as a DSNless Connection
Hi All,
Does anyone have a code snippet that shows how to connect to an excel spread
sheet as a dnsless connection?
Thanks,
Duane
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
