Whew!!! That is a long title! Also, I don’t demonstrate pulling data from Airtable in this video or code example. If you’d like that, check out my previous article on my client’s Airtable Reporting Dashboard using Google App Scripts, BigQuery, and Google Data Studio. The code to pull Airtable data is there. However, this is […]
Continue readingTag Archives: javascript
Programatically retrieving data from a website into a database
Summary: Our client wanted to extract data from a web portal. We wrote a VBA script to the requested information and store it in an Access database. The example below demonstrates the same technology, but the data is stored in Excel. Edit: 7/23/2017 – An improvement on this solution. Edit: 9/9/2016 – I posted a download […]
Continue reading