https://community.blueprism.com/t5/Product-Forum/SharePoint-List-OLEDB/m-p/86505#M37350 Hi Douglas - when I'm doing the select even, I'm getting ""Could not find installable ISAM"" returned when opening the connection using the same format you've provided. Did you run into that error? fyi I'm in a SP 2013 on-prem environment. Fri, 15 Jun 2018 00:52:00 GMT Anonymous 2018-06-15T00:52:00Z https://community.blueprism.com/t5/Product-Forum/SharePoint-List-OLEDB/m-p/86503#M37348 Anyone had any luck using an OLEDB connection to a SharePoint list to perform updates? I have made a modified OLEDB Object to make a connection string "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=1;RetrieveIds=Yes; DATABASE=http://sharepoint.yourdomain.com/Documents/;LIST={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698}; " and this works fine when performing select statements. When performing action statements(INSERT, UPDATE) the object hangs on the coding stage. I have tired different IMEX numbers, as this is the recommendation, but still no luck. Here is the code from the Code object Dim command As New OleDbCommand(queryString" input SQL", moConnection"input connection" ) Try command.ExecuteNonQuery() Catch ex as Exception runErr"output error"=ex.Message End Try Mon, 18 Sep 2017 20:12:00 GMT https://community.blueprism.com/t5/Product-Forum/SharePoint-List-OLEDB/m-p/86503#M37348 douglas.h.burke 2017-09-18T20:12:00Z https://community.blueprism.com/t5/Product-Forum/SharePoint-List-OLEDB/m-p/86504#M37349 Hi Douglas, First- set the connection, and check for the provider(i.e, ""Microsoft.Jet.OLEDB.4.0""). Then check for the password, If password = 'yes' ""Provider="" & [Provider] & ""; Data Source="" & [Database] & ""; Jet OLEDB:Database Password="" & [Password] &"";"" If password = 'no' ""Provider="" & [Provider] & ""; Data Source="" & [Database] & "";"" Second- open the connection, with code stage as- If moConnection Is Nothing Then moConnection = New OLEDBConnection(ConnectionString) moConnection.Open() End If Third- use the code to execute the query- If moConnection Is Nothing Then Dim strcon as String Dim path as String path = filePath strcon = ""Provider=Microsoft.ACE.OLEDB.12.0;Data Source=""+path+"";Extended Properties=Excel 12.0"" moConnection = New OLEDBConnection(strcon) moConnection.Open() End If Fourth- close the connection, with code stage as- moConnection.Close() moConnection.Dispose() moConnection = Nothing Mon, 27 Nov 2017 10:18:00 GMT https://community.blueprism.com/t5/Product-Forum/SharePoint-List-OLEDB/m-p/86504#M37349 DineshMani 2017-11-27T10:18:00Z https://community.blueprism.com/t5/Product-Forum/SharePoint-List-OLEDB/m-p/86505#M37350 Hi Douglas - when I'm doing the select even, I'm getting ""Could not find installable ISAM"" returned when opening the connection using the same format you've provided. Did you run into that error? fyi I'm in a SP 2013 on-prem environment. Fri, 15 Jun 2018 00:52:00 GMT https://community.blueprism.com/t5/Product-Forum/SharePoint-List-OLEDB/m-p/86505#M37350 Anonymous 2018-06-15T00:52:00Z