switch (filetype)
        {
            case ".xls": //Excel 97-03
                connString = ConfigurationManager.ConnectionStrings["Excel03ConString"].ConnectionString;
                break;
            case ".xlsx": //Excel 07
                connString = ConfigurationManager.ConnectionStrings["Excel07ConString"].ConnectionString;
                break;
        }
        connString = String.Format(connString, path, "Yes");
        OleDbConnection conn = new OleDbConnection(connString);
        if (conn.State == ConnectionState.Closed)
            conn.Open();
        DataTable dtExcelSchema;
        dtExcelSchema = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
        string SheetName = "";
        SheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString();
        string query = "SELECT * From [" + "DATA$" + "]";
        OleDbCommand cmd = new OleDbCommand(query, conn);
        OleDbDataAdapter da = new OleDbDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds, "Plan");
        tbl = ds.Tables["Plan"];