ODBC DSN for CSV Files

[thehockeyzone]

I have about 5 different CSV files inside a director with a CSV.DSN File. I receive an error when trying to connect to the csv files. I assume I need to use the ODBC tool to create a database connection. But the problem is it only accepts Access database as the path. Is there a way to link this up to CSV files? I need this because csv files are uploaded and then asp scripts treat it as a DB.

Mark

[bruce]

Try use oledb (dsnless connection)

An alternative to textfile is to store data in XML file which provide you with more structure data.

[b]quote:Originally posted by thehockeyzone

I have about 5 different CSV files inside a director with a CSV.DSN File. I receive an error when trying to connect to the csv files. I assume I need to use the ODBC tool to create a database connection. But the problem is it only accepts Access database as the path. Is there a way to link this up to CSV files? I need this because csv files are uploaded and then asp scripts treat it as a DB.

Mark
</blockquote id="quote"></font id="quote">