When the import windowssharepointservices list contains multiple values in Access 2007

Symptoms

Consider the following scenario:

•	You import the Microsoftwindowssharepointservices list into a Microsoft Office Access 2007 database table.
•	When you click to import the Windowssharepointservices list, select the display value instead of the ID for the field, find the stored in the other list value check box.
•	The Windowssharepointservices list contains at least one multivalued lookup column. Note Multivalued lookup This column looks at the values stored in the other Windowssharepointservices list.

In this scenario, when you are in table Datasheet view, view the Windowssharepointservices list to import a multivalued lookup column to display the ID number. However, the column does not display a display value.

Alternative methods

You can resolve this issue and import into Access 2007: The following two windowssharepointservices list

•	Windowssharepointservices list contains multivalued query columns
•	Windowssharepointservices list is a multivalued lookup column used to find data

To do this, follow these steps:

1.	Start Access for 2007 years.
2.	The Microsoft Office button opens in turn.
3.	Locate the database you want to open, and click Open.
4.	On the External Data tab, click the SharePoint List Import group.
5.	Type the name of the SharePoint site, import the source data into the new table in the current database, and then click Next.
6.	In the Import column, click the Windowssharepointservices list to include the name of the multivalued lookup column.
7.	The Windowssharepointservices list that you click in the Import column is a multivalued lookup column used to find the data name.
8.	Click to select the display value in place of the ID for the field, find the stored in the other list value check box, and click OK.
9.	Click Close.
10.	In Datasheet view, open the Import table. Note The multivalued lookup column displays the displayed value.