?
Solved

Linking or automatcially uploading data to Google docs.

Posted on 2011-02-19
1
Medium Priority
?
1,487 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
[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
1 Comment
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
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 …
Suggested Courses

770 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