I've used the get external web data function in Excel (https://www.howtogeek.com/howto/24285/use-online-data-in-excel-2010-spreadsheets/) for importing sports scores, stock quotes and so on... It works great for small applications where i need to sort out information from multiple websites..

I am now trying out Access (want to build a simple application with a small data model and very simple reports which can be updated in various ways) - I was wondering if there is a "get external web data function" in Access also? or any other smart ways of getting data from websites into Access?

Posted 4 years ago