Link Access to Googlesheet

[Freezie]

Hi everyone,



I am new to this site, but I was wondering if anyone has tried linking a Googlesheet to a MS Access Desktop database. My intentions are to use Google Forms as a way for people to report information using mobile devices and use that information to populate an Access database table. I know there is likely better ways of doing this but I work for a municipality and we have literally no money. If you know of a better way of doing this feel free to let me know .

How I assume this can work is by publishing the Googlesheet that is linked to the Google Form online and use Access Data from web to get it to refresh the information from the website. Does anyone know if this works or if this will cause loose security issues?

Thank you for any help on this!

[June7]

Have you searched web on this topic?

http://techcogitation.blogspot.com/2...-ms-excel.html

https://answers.microsoft.com/en-us/...c-dd20d23e8d06