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).
You can use a connection
string similar to this:
The select statements should look like this:
SELECT * FROM listName
You can use the Item-IDs as primary keys for
How to get the SharePoint list guid in
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: