C#

umaheshchandra wrote:

send me the code

field_name1 | field_name2 | field_name3
---------------------------------------
values      | values      | values

using Microsoft.Data.Odbc;
using System.Data;

....some code...

DataTable dt = new DataTable();
OdbcDataAdapter adapter;
OdbcConnection csvDB;

csvDB = new OdbcConnection("Driver={Microsoft Text Driver (*.txt; *.csv)}; Readonly=true;DBQ=[dir where is your file]");
adapter = new OdbcDataAdapter("SELECT * FROM [filename].csv", csvDB);
adapter.Fill(dt);

foreach(DataRow dr in dt.Rows)
{
    .....
    with INSERT queries put it to your SQL DB.
}