Graphics

 View Only
  • 1.  Datalinq table and Google Sheets

    Posted 10-24-2024 13:45

    I am familiar with using Excel Spreadsheets to pull data from Tables. The Table field in datalinq would look something like this:

    SELECT [COLUMN] FROM [TABLE NAME] WHERE [JERSEY] = @playernumber@

    I am trying to accomplish the same thing with Google Sheets and while I can get the datalinq to work, I have to publish each sheet individually, so there is no option in datalinq to select a "table". So, the question is, what do I put in the FROM brackets? Leaving it blank or removing the FROM section altogether doesn't give any results. 

    Anyone have any success with tables in Google Sheets?



    ------------------------------
    Matt Finlayson
    Brigham Young University
    ------------------------------


  • 2.  RE: Datalinq table and Google Sheets

    Posted 10-24-2024 14:42

    Hey Matt!

    I'm fairly certain that using SQL queries is a function of the ADODB datalinq, so it wouldn't be availble to use for Google Sheets, which have to come in via the RSS/HTTP datalinq.



    ------------------------------
    Zachary Fradette
    United States
    ------------------------------



  • 3.  RE: Datalinq table and Google Sheets

    Posted 10-24-2024 15:47

    CDATA has software (purchasable) that can format Google Sheets as a database, and then you can use the ADODB datalinq to connect to CDATA. 

    https://www.cdata.com/drivers/gsheets/