title: Updating Access from Data yielded in Excel
body: <p>I am trying to find the best way to extract report from Access into Excel and updating Access, once data has been yieled by Questionnaire participants.</p>
  
  <p>The data in Access is quite complex and large (contained in a single master table - 50+ columns &amp; 200K+ rows) - which doesn't make it easy on the eyes. </p>
  
  <p>I would like to extract reports from Access (essentially a subset of data - M columns out of N). The report will be updated by individuals (i.e. values updated) and will need to be fed back into Access.</p>
  
  <p>I'm looking for the most user - friendly approach to achieve the above. Does anyone have any ideas? </p>
  
  <p>Ps obvious answers welcome, I am a complete Access/Excel noob - but have a background in MySQL, SQL Server.</p>