Query about storing the MS Excel sheet into database

Hi Nagender Prasad,

I have done it before some time it's may help you.

string holdcolumnname = "";

  //Array.ForEach(Directory.GetFiles((Server.MapPath("~/admin/Import/"))),

File.Delete); // Delete for all file in the Import Directory.

  string path = string.Concat((Server.MapPath("~/admin/Import/" +

youfileName)));
  directoryName.PostedFile.SaveAs(path);


  string temp = Path.GetExtension(path);

  if (temp == ".xls")

  comman = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data

Source=" + path + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1;\";");

  else

  comman = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data

Source=" + path + ";Extended Properties=\"Excel 12.0;HDR=YES;\";");
  comman.Open();

  OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]",

comman);
  conn.Open();

  DbDataReader dr = cmd.ExecuteReader();

  dt.Load(dr);