Connection to Google Calendar (1 Viewer)

Krayna

Member
Local time
Today, 06:23
Joined
Sep 24, 2020
Messages
475
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

I’m here to help
Staff member
Local time
Yesterday, 22:23
Joined
Oct 29, 2018
Messages
16,572
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

Nifty Access Guy
Staff member
Local time
Today, 06:23
Joined
Jul 9, 2003
Messages
13,419
See this thread:-

 

Krayna

Member
Local time
Today, 06:23
Joined
Sep 24, 2020
Messages
475
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.
 

Attachments

  • google Cal.png
    google Cal.png
    129.6 KB · Views: 17
Last edited:

Users who are viewing this thread

Top Bottom