>Hi,
>
>I try to read some .csv files into a dataadapter. My CSV files don't have any columninfo in the first row, so I also want to have the first row.
>
>Can anybody give me the right connectionstring to open an csv file? Right now I use the following connectionstring:
>
>"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\myfiles\;Extended Properties='text;HDR=NO;FMT=Delimited'"
>
>Thanks,
>Sander Bouwmeester

I've not used CSV files via that manner, but is the syntax correct, can you actually use "Extended Properties" for the Microsoft Text Driver (ODBC)? Don't you have to use OLE DB (Provider=Microsoft.Jet.OLEDB.4.0)?

www.connectionstrings.com