csv file as datasource

Hi all. I see you can set up a csv file as a datasource. What would be the proper method to query that in CF? "CAN" it even be queried in CF? :) Would you name the columns in the first row, or is there a different way of specifying the columns? What about the fact that there won't be a table

Re: csv file as datasource

When querying csv , as far as remember you point the odbc to the irectory( like a db), and the file in the directory become the table (month.csv is like a table called month etc) and then you just query as usual Justin MacCarthy > > What about the fact that there won't be a table name? > -- > >

Re: csv file as datasource

On 9/24/00, JustinMacCarthy penned: >When querying csv , as far as remember you point the odbc to the >irectory( like a db), and the file in the directory become the table >(month.csv is like a table called month etc) and then you just query as >usual Great. I'll try it. What about column names.