Microsoft KB Archive/918809

Knowledge Base

Tables display ID numbers when you import a Windows SharePoint Services 3.0 list that contains a multivalue lookup column in Access 2007

Article ID: 918809

Article Last Modified on 11/16/2007

---

APPLIES TO

• Microsoft Office Access 2007
• Microsoft Windows SharePoint Services 3.0

---

SYMPTOMS

Consider the following scenario:

• You import a Windows SharePoint Services 3.0 list into a Microsoft Office Access 2007 database table.
• You click to select the Import display values instead of IDs for fields that look up values stored in another list check box when you import the Windows SharePoint Services 3.0 list.
• A Windows SharePoint Services 3.0 list contains at least one multivalue lookup column.
  

Note The multivalue lookup column looks up values that are stored in another Windows SharePoint Services 3.0 list.

In this scenario, when you view the imported Windows SharePoint Services 3.0 list in the table datasheet view, the multivalue lookup column displays ID numbers. However, the column does not display the display values.

WORKAROUND

To work around this behavior, you can import the following two Windows SharePoint Services 3.0 lists into Access 2007 at the same time:

• The Windows SharePoint Services 3.0 list that contains the multivalue lookup column
• The Windows SharePoint Services 3.0 list that the multivalue lookup column uses to look up data

To do this, follow these steps:

1. Start Access 2007.
2. Click the Microsoft Office Button, and then click Open.
3. Locate the database that you want to open, and then click Open.
4. On the External Data tab, click SharePoint List in the Import group.
5. Type the SharePoint site name, click Import the source data into a new table in the current database, and then click Next.
6. In the Import column, click the name of the Windows SharePoint Services 3.0 list that contains the multivalue lookup column.
7. In the Import column, click the name of the Windows SharePoint Services 3.0 list that the multivalue lookup column uses to look up data.
8. Click to select the Import display values instead of IDs for fields that look up values stored in another list check box, and then click OK.
9. Click Close.
10. Open the imported table in datasheet view. Notice that the multivalue lookup column displays the display values.

STATUS

This behavior is by design.

Additional query words: AC2007 ACC2007 Access2007

Keywords: kbtshoot kbprb kbexpertiseinter KB918809

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.