Apps built with data abstraction

In Database abstraction with google apps script I introduced a library for separating data access from the database being used, using Google Apps Script as broker. The access into this was either via a library, or through DataHandler REST API

In this section I’ll write up apps that I’ve built using that. If you would like to write up something you have built, please contact me on the forum or GitHub

Accessing Google Sheets directly from Excel

Here’s a VBA app that uses Database abstraction with google apps script  via the DataHandler  library. You need to download the latest version of the cDataSet.xlsm workbook from Downloads  It’s made up of these components DataHandler REST API  which uses th…

db access to a variety of databases from Excel

Here’s a VBA app that uses Database abstraction with google apps script  via the DataHandler  library. You need to download the latest version of the dbAbstraction.xlsm workbook from Downloads . Note that a Google Script Webapp  is providing the gatewa…

Get Data From Google Docs

There have been a number of changes to Google Docs over the years each of which has provided more ways to do things. The latest is the new Sheets API V4, which is by far the best way to integrate Excel and Sheets. To see how to do that see Using the G…

pollHandler app and library

Here’s an app that uses Database abstraction with google apps script  via the DataHandler  library.  It’s made up of these components DataHandler  library, plus all of the known drivers. It can support any of these databases to store its data A Google…