Solved

Linking or automatcially uploading data to Google docs.

Posted on 2011-02-19
1
1,483 Views
Last Modified: 2012-05-11
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
Respectfully.
0
Comment
Question by:carlisle_cibf
1 Comment
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 34937189
I use Google Docs, but have never tried to manipulate them programatically. Here's the API guide, which you've probably already seen:

http://code.google.com/apis/documents/

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.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I have a large data set and a SSIS package. How can I load this file in multi threading?
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

806 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