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

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.

Connecting

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.