Read, update and delete using Microsoft.ACE.OLEDB.12.0

Connection string

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



The keyword "Database" specifies the SharePoint URL

The keyword "List" specifies the GUID value for the desired SharePoint list (list=table)

Query without specifying table names. Ie use "SELECT FROM table" or "SELECT FROM list" (same result from both).

Read more about Finding the Id (Guid) for a SharePoint List.