ODBC - Link to Gmail Spreadsheet

Posted on 2014-07-14
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
    LVL 84
    When you say "import to GMail", I assume you mean you want to move the spreadsheet to Google Docs (i.e.

    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

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

    Accepted Solution

    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: 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: 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

    Tx - yes is Google Docs.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Whether you’re looking to gather data for research or gather feedback on an idea, being able to build and distribute your own online survey is not only cost-effective, but allows you to reach a larger audience and receive results in real-time. Googl…
    If your app took Google’s lash recently, here are the 5 most likely reasons.
    This Micro Tutorial will demonstrate the easy use of Gmail embedding images in your email so the recipient of your email can view them in context.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now