.csv Access

[.Crobar]

I'm trying to create a data source in Administrator to a .csv file. Has anyone been able to do this? I'm trying out ColdFusion MX7. I've searched the forums and can't find any answers.

Thanks.

[coryd218]

don't know how to do it, but you can import/export the .csv file into ACCESS or whatever DB you use. Then set it as the DSN

[arniebld]

You can create an ODBC DataSource using the Microsoft Text Driver and specify
the directory where your text file are or will be uploaded to, then create a
ColdFusion DataSource as an ODBC Socket. You can then access those files i.e.
SELECT * FROM [fileName.csv]

[ignandis]

If the csv file does not have any column name or header, how do you reference the data (assume the data is either text delimited or tab delimited)?

Thanks.