Hi All,
I am a rookie in Microsoft Access trying to connect a public government stats table to my access file, giving me the ability to update the Access db from the website:

https://data.calgary.ca/Government/P...6zp6-pxei/data

I have a OData Endpoint of: https://data.calgary.ca/api/odata/v4/6zp6-pxei

I managed to link to Excel. But how do I do the same with Access? -- I seem to be hung up on the correct Connection String syntax. Could anyone provide this for me?

Thanks!