I have a CSV file that needs to go into SQL Server 2005 table using C#. I want to use SQL Bulk copy and OLEDB connection. Please provide me the necessary code example. I am new to use SQL bulk copy and OLEDB.
While inserting into database table from CSV file, i need to elminate the first three rows and last row from CSV file also.