A CSV can be see as a relationnal database on which you do sql statement.
You can easily access data in CSV files (Comma-Separated Values) using ADO.NET components.
All you need is to use the Jet engine thanks to a connection string like the following one:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\TxtFilesFolder\;Extended Properties='text;HDR=Yes;FMT=Delimited'"
Note: "HDR=Yes" indicates that the first row contains columnnames, not data (source: connectionstrings.com).
Then you use it as as follows :
"SELECT * FROM data.txt"
See more infos in
http://www.dotnet-fr.org/sections.php3?op=viewarticle&artid=59
--
Cheers,
Gilles
Wish List
