public static DataSet ExcelToDS( string Pathm, string TableName) ... { DataSet ds = new DataSet(); try ... { string strConn = " Provider=Microsoft.Jet.OLEDB.4.0; " + " Data Source= " + Path + " ; " + " Extended Properties=Excel 8.0; " ; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); string strExcel = "" ; OleDbDataAdapter myCommand = null ; strExcel = string .Format( " select * from [{0}$] " ,TableName); myCommand = new OleDbDataAdapter(strExcel, strConn); myCommand.Fill(ds, TableName); } catch (Exception ex) ... { System.Windows.Forms.MessageBox.Show(ex.Message); } return ds; }