System.Data.Odbc.OdbcConnection conn;
DataTable dt = new DataTable();
System.Data.Odbc.OdbcDataAdapter da;
string connectionString;
string importFolder;
string fileName;
string strsqlconn = "Data Source=(local);Initial Catalog=<database_name>;Integrated Security=True;";
SqlConnection oSqlConn = new SqlConnection(strsqlconn);
oSqlConn.Open();
importFolder = @"C:\SQL Server Load\CSVLoadTest";
fileName = "TestDataCSV.csv";
connectionString = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + importFolder + ";";
conn = new System.Data.Odbc.OdbcConnection(connectionString);
da = new System.Data.Odbc.OdbcDataAdapter("select * from [" + fileName + "]", conn);
da.Fill(dt);
SqlBulkCopy bulkCopy = new SqlBulkCopy(strsqlconn);
bulkCopy.DestinationTableName = "CSVData";
bulkCopy.BulkCopyTimeout = 600;
bulkCopy.WriteToServer(dt);
conn.Close();
oSqlConn.Close();</database_name>