So I have been tossing around ideas over how to do this, and have yet to come up with one.

So I have a spreadsheet in Google Docs that is updated via a Google Docs form. I know I can manually save the spreadsheet to a .xls file on the local machine and link from there, but I want to do one better.

I am trying to come up with a way for Access to link to the spreadsheet directly in Google Docs. I have looked at a program called "Gladinet" which puts your Google Docs as a network drive, however, Access does not want to link to a file in their as it spits out the error "Only XML files can be imported from an Internet Address".

Has anyone attempted such a feet, or should I just accept the fact that I am going to have to manually save the file from Google Docs to my local machine.