Google Sheet Linkage (1 Viewer)

[GC2010]

Is there a way to link a google sheet into Access (similar to how you would link a Sharepoint table or ms sql table) and I can use that as the datasource of an access form?

 

[theDBguy]

Hi. I think it's possible if you have an appropriate ODBC driver.

 

[June7]

Did you web search this topic?

Update Google Sheets Data with a Microsoft Access Linked Table

Update Google Sheets data by creating a linked table in Microsoft Access with the CData Google Sheets ODBC Driver.

www.cdata.com

https://answers.microsoft.com/en-us...s-simple/9cd275e0-8006-433d-923c-dd20d23e8d06

 

[GC2010]

I did do a google search, but my situation is that the sheet already exists and I am not the owner, I am a sharee so not sure if that solution would work for me :/