Need Colin
@isladogs to have a look at it!
The video in post #1 shows one of the main reasons why Access needs its own version of Excel's Power Query AKA Get & Transform
Unfortunately it can't be done that easily in Access.... so it is probably easiest to import to Excel then link or import that data to Access.
However you can still get a lot of data directly into Access from the web by various means.
There are numerous examples. Here are a few of mine:
1. Web scraping
Here are 2 examples -
a) grabbing the latest version number from a web page and updating if it is newer:
This example app is designed to show how users can be alerted to program updates on a specified web page.
www.isladogs.co.uk
b) downloading a list of all addresses for a selected postcode together with the latest house prices
This free app is used to get a list of addresses & house price info for selected UK postcodes together with the geo-coordinates and a static Google map for that postcode
www.isladogs.co.uk
2. Downloading data to a local table using APIs with the data usually in JSON/XML/CSV format.
For example, the latest currency exchange rates
This free Access app gets the latest currency exchange rates from an online data source in JSON format
www.isladogs.co.uk