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


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.


This connection string (Read, update and delete using Microsoft.ACE.OLEDB.12.0) can be used for connections to SharePoint.

Articlesread all »

Not the right connection string for you?

Start over in the connection string reference index.

You can also get help in the Q&A forums where you can ask your own question.

The kb articles contains how-tos and instructions and you can search for anything if you're not sure were to look.