Forum Discussion
Linking Microsoft Forms to Microsoft Access
At the moment, I am working on a project receiving responses via Microsoft Forms. This stores these in an Excel doc accessible through the website link to the form. Is there a way to connect Access d...
It's a .xlsx file, which MS Forms offers as an option on its Responses tab. It both allows you to hit the "View Results" tab to see the responses as individual records while on the same webpage, or to "Open in Excel", which will download them as a .xlsx attachment. So I suppose my question is whether Access is capable of importing those results directly from that results webpage, saving the process of downloading the file, or whether I'd be better off just automating the import process while storing the file locally.
The frequency it's updated with is ad hoc - it's whenever the Form receives a new response - we check it twice weekly.
The frequency it's updated with is ad hoc - it's whenever the Form receives a new response - we check it twice weekly.
I would be very surprised to learn that there is NOT a database behind that website, from which the MS Forms are retrieving the data for download to Excel. If I'm right, then you should be able to get a connection directly to that database (maybe SQL Server, but also possibly MySQL or something else).
If you can do that, then neither MS Forms nor Excel need to be involved.
That said, you will need to find out a) if the data is available in a database on the server hosting the website and b) if so, can you get a connection to it.