Solved

Linking or automatcially uploading data to Google docs.

Posted on 2011-02-19
1
1,481 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
Comment Utility
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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 …

743 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now