Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

View products that this article applies to.

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.

↑ Back to the top

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.

↑ Back to the top

Status

This behavior is by design.

↑ Back to the top

Keywords: KB918809, kbexpertiseinter, kbprb, kbtshoot

↑ Back to the top

Article Info
Article ID : 918809
Revision : 2
Created on : 11/16/2007
Published on : 11/16/2007
Exists online : False
Views : 292