.csv first line skipped

[bbartlin]

I am reading in a .csv in C#. I don't have headers, so I need to read the first line. I say HDR=NO in the connection string and it still skips the first line. Any ideas on what I'm doing wrong?

Here is my connection string...
string strConnString = "Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=" + txtPathDir.Text + "\\" + ";Extensions=asc,csv,tab,txt;HDR=NO;";

 

[rdgerken]

See this article... seems that you need a schema.ini file.

http://www.dbforums.com/archive/index.php/t-1081719.html

this link here talks about how to use the text driver and how to use the schema.ini file

http://www.tek-tips.com/faqs.cfm?fid=3323

hope this helps

 

[rdgerken]

Oh, and here is an open source program doing some csv to database stuff...

http://www.codeproject.com/cs/database/FinalCSVReader.asp