ODBC - Link to Gmail Spreadsheet

Posted on 2014-07-14
Medium Priority
Last Modified: 2014-11-12
Say, I am able to create an ODBC link to a Microsoft XL Spread sheet. If I import the spread sheet into Gmail, is there a way to create an ODBC link to it? I would like to access this database via, for example, ACCESS.
Question by:shaunwingin
  • 2
  • 2
LVL 85
ID: 40194349
When you say "import to GMail", I assume you mean you want to move the spreadsheet to Google Docs (i.e. docs.google.com/spreadsheets)?

If so, then no, you cannot link to that spreadsheet. You'd need to download it to your local machine and link it from there.

Author Comment

ID: 40195329
We importing xls once into GMail or creating it from scratch.
The ODBC link to it is now required.
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 40196412
GMail is an email program. You can't "import" XLS into a email. You could embed an XLS file into an email, or you could attach an XLS file to an email - but you can't "import" one into an email.

So - are you referring to Google Docs, where you can actually view a spreadsheet online (or create one, or import one from your local system)? If so, then as before - No, you cannot do that without some sort of ODBC driver. You must download the file to your local machine and then link from there.

Some companies have created "ODBC Drivers" for Google Docs, like this one: http://www.rssbus.com/odbc/google-spreadsheet/. It's not free. Google Apps at one time had a "secure data connector", but it's been deprecated, and as far as I can tell there's nothing else published by Google to replace it.

Note that Google has some APIs that allow you some level of remote interaction with those spreadsheets: https://developers.google.com/google-apps/spreadsheets/?csw=1. I doubt you'd be able to do much from Access with those, as the APIs are generally oriented to other languages like .NET, Java, etc. I would assume that those "ODBC Drivers" are nothing more than wrappers around these APIs.

Author Closing Comment

ID: 40196662
Tx - yes is Google Docs.

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
This Micro Tutorial will demonstrate importing calendar invites from events such as webinars into your Google Calendar.
In this Experts Exchange video Micro Tutorial, I'm going to show how small business owners who use Google Apps can save money by setting up what is called a catch-all email address in their Gmail accounts. By using the catch-all feature, small busin…
Suggested Courses

864 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