Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 918809 - Last Review: November 16, 2007 - Revision: 2.0
Tables display ID numbers when you import a Windows SharePoint Services 3.0 list that contains a multivalue lookup column in Access 2007
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.
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:
- Start Access 2007.
- Click the Microsoft Office Button, and then click Open.
- Locate the database that you want to open, and then click Open.
- On the External Data tab, click SharePoint List in the Import group.
- Type the SharePoint site name, click Import the source data into a new table in the current database, and then click Next.
- In the Import column, click the name of the Windows SharePoint Services 3.0 list that contains the multivalue lookup column.
- 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.
- 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.
- Click Close.
- Open the imported table in datasheet view. Notice that the multivalue lookup column displays the display values.
This behavior is by design.
APPLIES TO
- Microsoft Office Access 2007
- Microsoft Windows SharePoint Services 3.0
| kbtshoot kbprb kbexpertiseinter KB918809 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate