This Code will help to fetch the data from excel sheet and save the same into dataset.DataSet dataSet = new DataSet();using (OleDbConnection Connection = new OleDbConnection(constr)){using (OleDbDataAdapter DataAdapter =new OleDbDataAdapter(query, Connection)){DataAdapter.Fill(dataSet, "Amt1");DataAdapter.AcceptChangesDuringFill = false;}}