:) Access Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\temp\sample.mdb
dBASE III Driver={Microsoft dBASE Driver (*.dbf)};DBQ=c:\temp; DriverID=21 dBASE IV Driver={Microsoft dBASE Driver (*.dbf)};DBQ=c:\temp; DriverID=277 dBASE 5.0 Driver={Microsoft dBASE Driver (*.dbf)};DBQ=c:\temp; DriverID=533 Excel 3.0/4.0 Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\temp; DriverID=278 Excel 5.0/7.0 Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\temp\sample.xls;DriverID=22 Excel 97 Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\temp\sample.xls;DriverID=790 Oracle Driver={Microsoft ODBC Driver for Oracle};Server=OracleServer.world;Uid=demo;Pwd=demo Paradox 3.X Driver={Microsoft Paradox Driver (*.db )};DBQ=c:\temp;DriverID=26 Paradox 4.X Driver={Microsoft Paradox Driver (*.db )};DBQ=c:\temp;DriverID=282 Paradox 5.X Driver={Microsoft Paradox Driver (*.db )};DBQ=c:\temp;DriverID=538 SQL Server Driver={SQL Server};Server=myserver;Database=pubs;Uid=sa;Pwd= Text/CSV Driver={Microsoft Text Driver (*.txt;*.csv)};DefaultDir=c:\temp Thank you, Joseph DeVore VeloxWeb Technologies -----Original Message----- From: Kurt Ward [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 1:35 PM To: CF-Talk Subject: RE: XLS as a DSNless Connection 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists