you can try using this code. here a function write in C#. you put excel file name and sheet name then function return a datatable according your excel file data. also you can use this datatable any your purpose.
Code Here:
public DataTable GetExcelSheetData(string excelFileName, string excelSheetNames)
{
OleDbConnection con = null;
DataTable dt = new DataTable();
String conStr = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + excelFileName + ";Extended Properties=Excel 8.0;";
con = new OleDbConnection(conStr);
con.Open();
OleDbCommand cmd = new OleDbCommand("select * from [" + excelSheetNames + "]", con);
OleDbDataAdapter oleAdapter = new OleDbDataAdapter();
oleAdapter.SelectCommand = cmd;
oleAdapter.FillSchema(dt, SchemaType.Source);
oleAdapter.Fill(dt);
con.Close();
return dt;
}