Originally Posted by Martin Wulfe
link my Access database to a Google sheet?
In this blog:-
Bruce demonstrates how to upload and download to an Excel spreadsheet.
In other words there's nothing on Bruce's site directly related to MS Access, (I don't think) however if the code works with VBA in Excel, then you should be able to adapt it to work with Microsoft Access...
I have a vague memory of trying to use Bruce's code to integrate MS Access and GAS a while back, however I think I ran into a problem in that I could not get one of the class modules to work.
I'm not really sure of my ground here, but I think it was a class module from somewhere else. A JSON one if I recall....
After the fact, I realised my mistake, in other words when you can't get something to work, it's invariably user error! In this case I think my mistake was, I was either using a module as a class or a class as a module.
I don't know if I've still got my unsuccessful attempts hidden away somewhere.
It is something I've been meaning to go back to. If you fancy tackling it, then maybe we could work on it together.
Sent from my SM-G925F using Tapatalk