Connect to a SharePoint list via OLE DB

How cool is this? Connect to SharePoint through OLDE DB connection string. You can then do things like SELECT * FROM listName; etc. Here’s how:

Read and write

Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes; DATABASE=http://pp1webofficelivecom.officelive.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)
Querying without specifying any table name. Ie use “SELECT * FROM table” or “SELECT * FROM list” (same result from booth).

Read only

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