Write using Microsoft.ACE.OLEDB.12.0

Connection string

This Microsoft ACE OLEDB 12.0 connection string can be used for connections to SharePoint.

Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes;
DATABASE=http://mysharepointsite.com/documents/;
LIST={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};

Use different SharePoint list connections for read (IMEX=2) and writes (IMEX=0), do not mix them.