Google sheet as data source

[Les Isaacs]

Hi all - does anyone know how to use a Google sheet as a data source for a local accdb?

 

[arnelgp]

you can download the sheet and create a linked table.
or use Excel to transform the data from google sheet and create a
linked table from the Excel workbook.

 

[ComputerVersteher]

Seems like there are several commercial ODBC-Drivers available for Google Sheets. Simply search for: google sheets odbc connection.

 

[Les Isaacs]

you can download the sheet and create a linked table.
or use Excel to transform the data from google sheet and create a
linked table from the Excel workbook.

Hi - I need the link to be dynamic, so that the data in the accdb updates as the data in the Google sheet is amended.

 

[Gasman]

They have an API ?

 

[arnelgp]

if you Transform the data to macro-enabled excel, you can have a
vba to Refresh the data:

Sub RefreshQueryTable()
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your sheet's name

    Dim qt As QueryTable
    For Each qt In ws.QueryTables
        qt.Refresh BackgroundQuery:=False
    Next qt
End Sub