title: Easily using Excel data in SQL Server
body: <p>I am regularly required to compare data sent to me in Excel spreadsheets with data that lives in SQL Server.  I know that you can connect SQL Server to spreadsheets but it always seemed clunky</p>
  
  <p>This is really a post to show off my solution but I would love to hear other peoples ideas.</p>