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