Query Tutorials Index:
API Function Query ExampleAccess API Tutorial
Need to use an API to get data from a website into an Access database? This is a fairly common requirement and we show a great example on this page. Here we are going to retrieve the current price of stocks trading out there in the stock market. We will use Yahoo Finance's API for this.
Microsoft Access is a fully capable database and it's primary limitations is the number of concurrent users it will support. Generally, we recommend a limit of 10 to 15 users.
We create databases large and small. Some of our databases help run entire small businesses. We also handle unique businesses such as flyrod manufacturing, cheese making, marina management, and cable tv inventory.
In the example below we first create a Public Function containing the API code. The we call that function while using a Select Query to retrieve our stock symbols from our table.
Once see how to dynamically retrieve the current stock prices you can show them in a form or change to an Update Query to save the in a table along with the current date. If you wanted to you could create an Access database that would wake up once a day on update your database of stock quotes. This way you can plot them over time.
Here is the table we are using for this SQL API function example:
Next is the function we have created:
And the Access query contains this query code:
And when we run the query we get:
Contact us here at Blue Claw Database Design if you feel we could help you get your job done quickly. We promise to only charge when we delivery a product or component and we will always tell you how much programming will cost up front. We have programmed more than 500 databases all over the USA and all over the world. Contact us today!
You can also read more about Yahoo Finance's stock quote api. There is a lot more information about each stock that can be pulled using the API.
Copyright 2000-2017 Blue Claw Database Design
Development in Microsoft Access, Microsoft SQL/Server and Azure
See our SQL/Server Development and Access Migration Tutorials