In order to do a "regular" (select something from tablename) query, you have to define "named regions" (or something like that) in your Excel spreadshet. Otherwise, use this syntax: select * from "worksheetname$" A worksheet is a table, and you must put quotation marks, and the dollar sign, in there. (What you're doing is setting up a named region on the fly with this syntax) -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Philjpap wrote: > All, Through the ColdFusion Administrator I'm adding an ODBC > datasource to an EXCEL file. The file verifies correctly. But, I'm > getting an ODBC error when using CFQUERY. Has anyone accomplished this > type of task before? Is there some sample code for querying this type > of datasource? Thanks,Tyrone ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
