title: Compare-Object not working if I don't list the properties
body: <p>I have 2 Excel spreadsheets I am trying to compare:</p>
  
  <pre><code>$OleDbAdapter = New-Object System.Data.OleDb.OleDbDataAdapter “Select * from [Report$]“,”Provider=Microsoft.ACE.OLEDB.12.0;Data Source=S:\FIS-BIC Reporting\Report Output Files\Product-Marketing\TEST_XI\ECM - Pipeline by LOB_04182013_040544.xls;Extended Properties=”"Excel 12.0 Xml;HDR=YES”";”
  $RowsReturned = $OleDbAdapter.Fill($DataTable)
  
  $OleDbAdapter2 = New-Object System.Data.OleDb.OleDbDataAdapter “Select * from [Report$]“,”Provider=Microsoft.ACE.OLEDB.12.0;Data Source=S:\FIS-BIC Reporting\Report Output Files\Product-Marketing\ECM - Pipeline by LOB_04182013_074004.xls;Extended Properties=”"Excel 12.0 Xml;HDR=YES”";”
  $RowsReturned2 = $OleDbAdapter2.Fill($DataTable2)
  
  Compare-Object $DataTable $DataTable2 
  </code></pre>
  
  <p>It returns nothing. I know that in the 6th column, they are different. If I specify "-property F6", it does return the difference.  Any idea why it doesn't unless I specify the property? The number of columns can vary (though will be the same for each of the files in the comparison), so specifying the properties specifically won't work.</p>