How to connect a SharePoint list to another SharePoint list using an OLE DB connection string?


The SharePoint Business Data List Connector BDLC can be used to pull data into a SharePoint list from another SharePoint list for any reason (e.g. from other site collection or installation).


SQL Server Cobbection to SharePoint List



You can use a connection string similar to this:


Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=1;RetrieveIds=Yes; DATABASE=;LIST={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};


The select statements should look like this:


 SELECT * FROM listName


You can use the Item-IDs as primary keys for updating.


How to get the SharePoint list guid in browser?

Go to the list settings page. Right click on "Title, description and navigation" and copy the URL. Paste that into notepad and copy everything after "List=" in the string. That's your URL Encoded GUID for the list. All you need to do is decode it.


How to decode the SharePoint List guid (and any other encoded URL)?

You can use this page to decode encoded URLs:

SharePoint  to SharePoint, OLEDB

Simple solution for data integration and synchroniation

If you are looking for a simple data and file synchronization and integration tool, you should try Layer2 Cloud Connector. This tool is intuitive, secure and with no data limit. You can synchronize automatically in the background, one way or two way - and you can use it even without IT knowledge. We offer you three licenses, a free trial of Layer2 Cloud Connector and a life product demo.




Layer2 leading solutions product regsitration icon: a grey square with a big orange pen symbol.

Register for free download.

Keep your Sharepoint in sync. Download and try today.

Contact Us Icon for Layer2 leading solutions

Questions? Contact us.

We are here to help. Contact us and our consulting will be happy to answer your questions.