title: Compare rows in a spreadsheet with records in a database
body: <p>I have an Excel spreadsheet provided as a report, when really its more of a database, with the row number acting as primary key.  I need to compare some columns in this set with a different set of records from an Access 2007 database.  To make matters more complicated, this needs to be done automatically, without user input, on a regular schedule.  </p>
  
  <p>What is the best way to get the data out of the spreadsheet, and what is the best way to run the comparison.  As for getting data out of the spreadsheet, ACEDAO seems the best option, since this is Excel 2007, but MSDN has no information I could find on how to query Excel using DAO/ACEDAO, only to export to Excel using DAO/ACEDAO.  As for running the comparison, beyond comparing each column of each entry, I can't figure out a better way to do it.</p>