IBM i Global

 View Only
  • 1.  ODBC connection to Google Sheets

    Posted Thu November 10, 2022 08:56 AM
    We are migrating from Excel to Google Sheets.
    Does anyone know how to make the connection from the ODBC conneciton on the PC to Google Sheets.
    We have many data exports that we currently do to excel and this would be mission critical to continue after we migrate.
    thank you,
    Marlene

    ------------------------------
    Marlene Black
    ------------------------------


  • 2.  RE: ODBC connection to Google Sheets

    IBM Champion
    Posted Thu November 10, 2022 08:52 PM
    Edited by Satid Singkorapoom Thu November 10, 2022 09:02 PM
    Dear Marlene

    Please check the instruction here : Setting Up Google Sheets ODBC Connection: 2 Easy Steps   This is for an non-IBM i ODBC but it appears that setting up a DSN is a normal process done from Windows. 


    ------------------------------
    Right action is better than knowledge; but in order to do what is right, we must know what is right.
    -- Charlemagne

    Satid Singkorapoom
    ------------------------------



  • 3.  RE: ODBC connection to Google Sheets

    Posted Thu November 10, 2022 08:56 PM
    Hello Satid,
    Yes, I will try this.
    thanks,

    Marlene Black

    Information Technology

    Hansen Distribution Group

    96-1282 Waihona St.

    Pearl City, Hawaii   96782

    Phone:    808.455.0705

    Cell:       808.561.8116 

    Email:     mblack@hansenhawaii.com

    Website:  www.HansenHawaii.com








  • 4.  RE: ODBC connection to Google Sheets

    IBM Champion
    Posted Fri November 11, 2022 07:37 AM
    Hi Marlene, 

    It looks like CDATA offers an ODBC driver for the desktop.

    You could also easily create something in Python that can be called to export/update data in a spreadsheet on Google Sheet that runs natively. 

    Here's a sample video I found.

    You can google: "odbc export to google sheets". for more options



    ------------------------------
    Richard Schoen
    ------------------------------