Solved

Linking or automatcially uploading data to Google docs.

Posted on 2011-02-19
1
1,482 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

895 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

13 Experts available now in Live!

Get 1:1 Help Now