User Profile List in SharePoint 2010

By Michael Doyle posted 11-19-2010 01:00


The User Information List is a list of every user that has ever been to your site collection or that has been added as an individual user. You may want to use this list for your own purposes. One of the ways you can do this is via Access. The steps to link to it are below.

Connecting to the SharePoint List from Access 2010

  1. Open up your Access database.
  2. Click on the External Data tab.
  3. Click on More and then SharePoint List as shown below
  4. Enter the top level site collection (i.e. http://howardcentral)
  5. Click on Link to the data source by creating a linked table.
  6. Click Next.
  7. Select UserInfo from the lists of lists as shown below.
  8. Click OK.
  9. You will now have a list of all the users that have been to your site (or that have been added individually).

You will now be able to use a list of users (and a host of other information) so that you can do things like create a phone book to be printed out. Old school, but you would be amazed at how often this request comes up and Access is an amazing tool for creating good looking reports.


#SharePoint #sharepoint #Users