how can i import data from excel shit in sql server using c#

hi,

Please try this.

I a trying to use bulkcopy for data transfer.

Code below

Create sql database table where you want to store data.

public class FileUpload
  {
 void importdata(string excelfilepath)
  {
  //declare variables - edit these based on your particular situation
  string ssqltable = "tTableExcel";
  // make sure your sheet name is correct, here sheet name is sheet1, so you can change your sheet name if have
 
  string myexceldataquery = "select student,rollno,course from [sheet1$]";
  try
  {
  //create our connection strings
  string sexcelconnectionstring = @"provider=microsoft.jet.oledb.4.0;data source=" + excelfilepath +
  ";extended properties=" + "\"excel 8.0;hdr=yes;\"";
  string ssqlconnectionstring = "server=mydatabaseservername;userid=dbuserid;password=dbuserpassword;database=databasename;connection reset=false";
 
  //execute a query to erase any previous data from our destination table
  string sclearsql = "delete from " + ssqltable;
  SqlConnection sqlconn = new SqlConnection(ssqlconnectionstring);
  SqlCommand sqlcmd = new SqlCommand(sclearsql, sqlconn);
  sqlconn.Open();
  sqlcmd.ExecuteNonQuery();
  sqlconn.Close();
  //series of commands to bulk copy data from the excel file into our sql table
 
  OleDbConnection oledbconn = new OleDbConnection(sexcelconnectionstring);
  OleDbCommand oledbcmd = new OleDbCommand(myexceldataquery, oledbconn);
  oledbconn.Open();
  OleDbDataReader dr = oledbcmd.ExecuteReader();
  SqlBulkCopy bulkcopy = new SqlBulkCopy(ssqlconnectionstring);
  bulkcopy.DestinationTableName = ssqltable;
  while (dr.Read())
  {
  bulkcopy.WriteToServer(dr);
  }
 
  oledbconn.Close();
  }
  catch (Exception ex)
  {
  //handle exception
  }
  }
  }
Hope this help.