Is there a way in CF4.5? Duane
-----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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

