api in an access database

Recommended Posts

Assuming you have gotten a KEY for the API (if not follow the directions here:

then you can construct a URL in Access (using vb) similar to this<*Your Key*>

where the <*Your Key*> = the key you had generated.

After which it will return a JSON object that you will need to parse out into a vb object, which then you should be able to import into your data base.

Here is a thread which should get you started:


It will take a bit of work, but is well worth it.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now