Good day everyone,
I'm new to Access and would like to know if it is possible to setup an automate synchronisation reading data from SQL database to automatically update a SharePoint list.
My scenario is the following:
I have created in access external data connection to few SQL server tables. Then linked them as needed in Access.
I created a query to append some columns from the results in a SharePoint list. (SharePoint Online)
I would like to have my SharePoint list automatically updated by any changes occurring in the source SQL tables. (Read only connection, I don't want to update anything in the SQL database from SharePoint).
I'd like a refresh rate quite close to real time, perhaps few minutes.
I'd like to have it refreshed even when I'm off work and my computer shutoff.
So far I'm able to manually refresh but I can't find how to automate that part
Could someone tell if it is possible to develop such solution?
If possible, could you please provide me with some direction?
If not possible, could you please provide me with direction to an alternate solution?
Thanks in advance for your support
Have a good day
Adrien