Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Create Google Apps Calendar Event from Access

Posted on 2010-11-23
5
Medium Priority
?
2,197 Views
Last Modified: 2014-11-12
I am moving our email from an in-house exchange server to google apps.

I currently create Calendar appointments in shared calendars using an Access 2003 Program. Now I need to achieve the same thing by creating events in Google Calendars from Access using VBA.

Any Ideas how this is done, what my code should be?

I see it's possible with .net but not sure how to do it with Access.

http://code.google.com/apis/calendar/data/2.0/developers_guide.html

Thanks,
0
Comment
Question by:stanbond
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 19

Accepted Solution

by:
Bardobrave earned 2000 total points
ID: 34195947
Google calendar is an web development API, so to include it in a project and be able to interact with it's classes into your code, you need to develop a web application (except if Google has developed a version of this app for desktop apps, but I didn't heared of that before).

What you can do is to create a simple classic ASP page with VBscript (wich is somewhat similar to VBA) that connects with your Access and tends a bridge between your Access application and Google's API.
0
 
LVL 85
ID: 34195952
You __might__ be able to use SOAP to manage this, but a much better solution would be to build a small .NET utility you could call from your Access app to add appointments and such. Google Apps are intended to be manipulated from a web-based platform, hence the very web-centric sort of interface.
0
 

Author Comment

by:stanbond
ID: 34196058
Is it as easy as posting a simple http:// address with the events details in the link?
0
 
LVL 85
ID: 34196098
From a quick review of the link you posted, no, it's not something you can pass in via a http link. You'll have to use the API to automate this.
0
 
LVL 19

Expert Comment

by:Bardobrave
ID: 34196234
For being able to use the API you need to load it into your project, like a external reference of Access, the problem is that APIs are designed for work on web environments, so you can't add a reference to it into your project and you cannot use it's classes or methods.

As LSMConsulting stated before you probably could make something through SOAP, but I think it could be a lot easier to simply use a little web app that makes the interface between your Access application and Google's Calendar API.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This Micro Tutorial will demonstrate importing calendar invites from events such as webinars into your Google Calendar.
In this Experts Exchange video Micro Tutorial, I'm going to show how small business owners who use Google Apps can save money by setting up what is called a catch-all email address in their Gmail accounts. By using the catch-all feature, small busin…
Suggested Courses

661 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question