Using Weather API in Microsoft Access for Current Data

In this Microsoft Access tutorial, I will show you how to use a web-based weather API to pull current weather data into your database. We will cover API basics, obtaining and using an API key, and importing weather data into AAccess

from (a Member) asks: I'm taking your Microsoft Access Expert 24 class, and in there you give a link to an RSS weather feed from WeatherUnderground. That feed no longer exists. Are there any other sites that you can recommend that still work?

Prerequisites

• Intro to VBA
• Web API
• Find Between

Links

• AccuWeather
• OpenWeather
• OpenWeather Signup Page
• OpenWeather API Call City, State
• OpenWeather API Call ZIP Code
• OpenWeather API Call Coordinates

Recommended Courses

• Access Expert 24
• Access Developer Courses

Up Next

• Weather API, Part 2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, web-based weather API, current weather data, Microsoft Access VBA, weather conditions Access, OpenWeatherMap API, Access API call, API key setup, retrieve weather Access, XML weather data Access, JSON to XML Access, Access weather import, temperature data Access, wind speed Access, humidity data Access, parse XML Access