Connection to Google Calendar

[Kayleigh]

Hi,
I have developed an Access DB with SQL server backend. Users enter appointments scheduled and I want to link to Google Calendars to update and delete appointments via my Access application. I prefer not to use Outlook. Rather do it direct. Do I need to use an integration solution like Zapier or will I be able to develop myself?
Any pointers would be greatly appreciated.

 

[theDBguy]

Hi. You should be able to develop one yourself, but you will need to use Google API and have a developer account/token to access it.

 

[Uncle Gizmo]

See this thread:-

Create and edit google calendar events

Im looking for areference how to create a google calendar events. Next step will be to be able to edit them.

www.access-programmers.co.uk

 

[Kayleigh]

Hi,
Thanks for the direction points above.
I stumbled on this youtube link which explained how to integrate Google Calendars into SQL Server using Visual Studio. It was quite a journey to follow but I did manage to get it working to the point that the calendars are linked to a similarly structured table (although it wasn't clear what data types to use).
My next problem is how to get access to the events within each calendar and edit/create etc through SQL server/VB?

I appreciate that this may not be your area of expertise.