DataTable dtEXCEL = new DataTable();
            string strConn;
            strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                     "Data Source="Filepath;" +
                     "Extended Properties=Excel 8.0;";

            OleDbConnection oleConn = new OleDbConnection(strConn);
            oleConn.Open();
            object[] _obj = new object[] { null, null, null, "TABLE" };

            DataTable dtNAME = oleConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, _obj);

            OleDbDataAdapter adp;

            if (dtNAME.Rows.Count > 0)
            {
                adp = new OleDbDataAdapter("SELECT * FROM [" + dtNAME.Rows[0]["TABLE_NAME"].ToString() + "]", oleConn);
                adp.Fill(dtEXCEL);
            }