Announcement

Collapse
No announcement yet.

Integrating Google Calendar with Database question

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Integrating Google Calendar with Database question

    Finally figured out how to pull data from Google Calendar. If I thought I was over my head before, now I'm drowning. I have no idea of how to move the data to an Access database. This database already has data from a local source so recreating the database every time I import Google data is not an option

    I will be querying Google every couple of hours, so how does one not overwrite the existing data or duplicate the existing Google data?

    As of now I will be adding data from both sources, so syncing stuff is also something that I am not familiar with. Any way to deal with this?

    Thanks for any suggestions.
    Don

    #2
    Have you looked at something like http://www.startvbdotnet.com/ado/msaccess.aspx

    I would be looking at SQL Insert or Update statements (If you are not familiar with these then this is a bit of an intro http://msdn.microsoft.com/en-us/libr...sql.90%29.aspx) to insert new records into the database. You might need to have a good idea of your database design first (primary keys/data types will need to either match or be formatted to suit your database).

    Your second source of data you might also need to check is not keeping the database connection open, I think (don't quote me on this) that you might only be able to connect once to the database and good practice is to close it after you have finished your insert or update.

    Comment


      #3
      Thanks; I'll check out the link.
      Don

      Comment

      Working...
      X