Create a link table to a simple Google sheet (1 Viewer)

[georg0307]

Dear All,

I'd like to create a linked table in my Ms Access Database (sorry if I don't attach it), connected to an online Google sheet.

before I give further info, is it possible?

My IT team give me an open door to connect, but I don't have an idea how to use it.

Thanks in advance

Georg B.

 

[Uncle Gizmo]

Something Like This?

VBA to add data to Google Sheets or pull data from Google Sheets

VBA to add data to Google Sheets or pull data from Google Sheets

www.access-programmers.co.uk

 

[Velocity]

Yes, it is possible to create a linked table in Microsoft Access that is connected to an online Google Sheet. However, you will need to have some knowledge of programming and database concepts in order to do so. Additionally, your IT team will need to provide you with the necessary information and access in order to connect to the Google Sheet.