Linking or automatcially uploading data to Google docs.

I would like to understand if I can automatically upload data to a Google  Spreadsheet.
Daily updates to feed the spreadsheets from sources like Access, SQL Server or Oracle.
Is there a way or API to do this? Could you provide and example.

Thank You
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
I use Google Docs, but have never tried to manipulate them programatically. Here's the API guide, which you've probably already seen:

As with all things web-based, you'll probably find it difficult to work with that API directly from Access. You'll certainly find this to be much easier to do from a .NET project rather than Access.

From a simple web search, however, it seems that while you can upload and replace a current document, you cannot modify the online document, nor can you sync a local document with a Google Docs document. So if you have a Spreadsheet stored on Google Docs, you could upload a replacement doc from your local diretory, but you couldn't hook into the web-based spreadsheet and update Cell(A1), if that's what you're after.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.