title: Import data into SQL server from web url
body: <p>I'm looking for some suggestions on how best to do this.</p>
  
  <p>We have a third party application which exposes reports through a URL.  When the URL is hit it creates a simple excel 2007 file containing the data.</p>
  
  <p>I need to bring this into a SQL 2008 database server.  This isn't a one time thing and has to be scheduled to run once a day.</p>
  
  <p>What is the best way to go about hooking the two up?</p>