Hi all,
I needed to get some of the SharePoint List data into Python, Matlab etc. As there were no dedicated connectors that would also combine well with SSO, I used ODBC to create a connection with Access DB. In this Access DB I linked the SharePoint list. It allows me to use basic SQL on sharepoint data from the code. That works reasonably well when it comes to running Select and Delete queries. However when it comes to Inserts it has encountered an issue when a duplicate record is added to a unique column. This breaks the linked connection in Access Db.
To restore it I need to open Access Db and resolve the conflicts there or refresh the SharePoint link. Is there any way to do through some command without opening the Access Db?