MSAccess VBA to send object to web URL like Google Sheets (1 Viewer)

[jysharp2003]

HI everyone,
Can't find it and wanted to poll everyone to make sure if there is an easy way to do this.
I have an Access database on my C drive that has an ever changing schedule for employees. Rather than send via email I wanted to create process in Access to save the new version of schedule to overwrite the previous version on Google Sheets.
Any ideas?

 

[Frothingslosh]

This might help:

VBA Write Info to Google Spreadsheet

VBA can write info to google spreadsheet by using GSpread.NET.
It opensource library allows to work with Google Sheets by using Microsoft Excel API.
see examples: http://scand.com/products/gspread/tutorial.html