title: Automated Update Of An Excel 2007 Table from a Centralized Data Repository (Excel Table)
body: <p>I have created and Excel 2007 based dynamic charting application that that charts various economic data.  The spreadsheet includes a Table that contains all the monthly economic data for about 25 different indices.   I would like to add a visual basic script that will enable the spreadsheet user (there will be many users using the same spreadsheet)  to push a button and have the visual basic script access a centralized data repository and update the economic data on the spreadsheet with new data in the central data repository. </p>
  
  <p>The users will be on the same Wide Area Network and will likely need to update thier spreadsheet monthly. However, anytime a user does an update the update should fetch all the rows required to bring the particular spreadsheet up-to-data.  </p>
  
  <p><strong>My Question is. What's the best way to tackle this problem?</strong>  Do excel Table have a query feature that would enable me to query the central repository with what amounts to a Select all sql statement and return all the rows or is there some other functionality that someone could suggest.   </p>
  
  <p>If someone can point me in the right direction, I think I can figure it out from there.</p>
  
  <p>Thanks for your input.</p>