Search code examples
vbasharepointconnection-stringrecordset

Connection to two (or more) sharepoint lists with ADODB

I can connect to a SharePoint list with ADODB this way :

Dim objCon As New ADODB.Connection
objCon.Open "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes;DATABASE=mysite/documents;LIST={xxxx-guid-xxxx};"

Dim rst As Recordset
Set rst = objCon.Execute("Select * from list1)

and it's working :).

Now, I would like to connect two list at the same time to do an inner join :

Set rst = objCon.Execute("Select * from list1 inner join list2)

but I don't find the syntax to put the second list GUID on the connection string. How can I do ?

Solution

  • From Microsoft http://msdn.microsoft.com/en-us/library/ee633650.aspx

    Selecting fields from multiple lists is not supported. You can create a dataset for each list and select fields from each dataset.

    I don't know your environement but to me the easiest way to accomplish this would be to create 2 Linked tables pointing on your SharePoint lists and then you can manipulate their data the way you want.