title: Retrieve URL JSON data in MS Access
body: <p>There is a web service that allows me to go to a URL, with my API-key, and request a page of data.  The data is returned as JSON.  The JSON is well-formed, I ran it through <a href="http://jsonlint.com/" rel="noreferrer">JSONLint</a> and confirmed its OK.  </p>
  
  <p>What I would like to do is retrieve the JSON data from <em>within</em> MS Access (2003 or 2007), if possible, and build a table from that data (first time thru), then append/update the table on subsequent calls to that URL.   I would settle for "pre-step" where I retrieve this information via another means.  Since I have an API key in the URL, I do not want to do this server-side.  I would like to keep it all within Access, run it on my PC at home (its for personal use anyway). </p>
  
  <p>If I have to use another step before the database load then Javascript?  But I dont know that very well.  I dont even really know what JSON is other than what I have read in Wikipedia. The URL looks similar to:</p>
  
  <pre><code>http://www.SomeWebService.com/MyAPIKey?p=1&amp;s=50
  </code></pre>
  
  <p><strong>where:</strong> p = page number
         s = records per page</p>