I think, but not positive, that each file in the directory refers to a table. So, in CF,
select Name from test1 - j -----Original Message----- From: Mario Martinez R. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 1:49 PM To: CF-Talk Subject: ODBC and cvs files Hi friends: I'm trying to make a query from a csv file (test1.csv). The way I thought was to make an ODBC entry for text files . In the ODBC entry I only can specify the directory not the file name. So I guessed I had to include that in the final query. There is something I'm missing . I will appreciate your help.Any new ideas could be great too. Down the code and what I see in my browser . Thanks for any help Mario //my code <cfquery name="InstrLedAttQuery" datasource="EkOutsideFiles" dbtype="ODBC"> SELECT * FROM test1.cvs </cfquery> //What I get in my browser Error Diagnostic Information ODBC Error Code = 42000 (Syntax error or access violation) [Microsoft][ODBC Text Driver] Cannot update. Database or object is read-only. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (199:1) to (199:75). Date/Time: 03/11/02 12:20:20 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 66.109.35.50 _________________________________________________________ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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