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