OleDB connection string

Hello,
I need help resolving a small issue when i use a OleDb connection string.

I am trying to create a string that will connect to a SharePoint list.

Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=1;RetrieveIds=Yes;DATABASE=http://sitebuilder/sitea/siteb/;LIST={0000000-0000-0000-0000-000000000};

The string works, however, one of my columns contains AD users. The column is returning these users as IDs (1, 4, 34 etc...)

I know there is a table used by SharePoint called UserInfo which contains the full name.

I need help connecting these two tables within the string above. I am not coding the connection, it's being entered into a reporting application, so my options are very limited.

Thanks in advance.

0 answers