Importing XL file to Oracle Database.

// Open excel file, read records then return as datatable
 // Author: Algem Mojedo  
 public DataTable xlsInsert(String pth, String Schema)
 {
     string strcon = string.Empty;
     if (Path.GetExtension(pth).ToLower().Equals(".xls"))
     {
                strcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
                                + pth +
                                ";Extended Properties=\"Excel 8.0;HDR=YES;\"";
     }
     else
     {
        strcon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="
                  + pth +
                 ";Extended Properties=\"Excel 12.0;HDR=YES;\"";

     }
     string strselect = "Select * from [Sheet1$]";
     DataTable exDT = new DataTable();
     using (OleDbConnection excelCon = new OleDbConnection(strcon))
     {
         try
         {
            excelCon.Open();
            using (OleDbDataAdapter exDA = new OleDbDataAdapter(strselect, excelCon))
            {
                exDA.Fill(exDT);
            }
         }
         catch (OleDbException oledb)
         {
            throw new Exception(oledb.Message.ToString());
         }
         finally
         {
             excelCon.Close();
         }
         for (int i = 0; i < exDT.Rows.Count; i++)
         {
            if (exDT.Rows[i]["CARDNO"].ToString() == string.Empty)  // colummn CARDNO must not emplty
            {
                exDT.Rows[i].Delete();
            }
         }
         exDT.AcceptChanges();
         if (exDT.Rows.Count == 0)
         {
             throw new Exception("File uploaded has no record found.");
         }
         return exDT;
    }