Home   Fees/Services   Access Templates   Tutorials   Tutorial Downloads   Articles   Search   Contact  Privacy  Links
SQL API Function Example
Yahoo Finance API Query

Query Tutorials Index:
Too Complex Query
Aggregate Query
Not In Operator
Choose Function
Crosstab Query
Date Time Query
SQL Delete Query
External Table Query
Report Filter Query
Group By Query
Having Query Clause
Histogram Query
Access Append Query
Master Detail Update
Order By Query
SQL Parameter Query
Predicate Query
Self Join Query
Scalar SubQuery
Master Detail Query
Select Query
Access SQL Select Top
SQL Union Query
SQL Update Query
Custom Query Function


MultiSelect Parameter Forms Access Tutorial

API Function Query Example

Access 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.

We have expert enterprise-level database development capabilities for cloud/web-based databases through our partnership with Jay McCormick and his team.

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:

get data from website via Access query

And the Access query contains this query code:

vb function in access query

And when we run the query we get:

access api query example

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.

A Blue Claw Software Design Template:

Meal Delivery Service Solution

A Blue Claw Database Design Article:

Cloud-Based Access Database

Blue Claw Database Design Downloadable Tutorial:
TransferText & OutputTo Microsoft Access Download.  

Microsoft Office:
MS Access 2000 Through Access 2016 & Office 365

Contact Information
Copyright 2000-2018 Blue Claw Database Design
Development in Microsoft Access, Microsoft SQL/Server and Azure

See our SQL/Server Development and Access Migration Tutorials