• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 404
  • Last Modified:

Lookup field not translating between Access 2007 database and MOSS 2007 lists

When I export and link my tables from Access 2007 into Sharepoint, all of the lookups disappear. For example, a filtered lookup (query) for values of type number meeting a certain criteria, only show up in Sharepoint as a column of type number and uses a text box rather than a drop down displaying multiple values returned by the filtered query. What can i do to solve this?
1 Solution
Micheal HuntSr. Software DeveloperCommented:
Tables that use a query to lookup values do not transfer the query when moving to SharePoint.  If you use a value list for the lookup in your table, that list will be transfered, but not the results of a query.  Unfortunately, this is a limitation of the transfer process.

Here's an article that goes into more depth about the limitations of transfering tables from Access to SharePoint: http://office.microsoft.com/en-us/access-help/export-a-table-or-query-to-a-sharepoint-site-HA001230314.aspx
BobHavertyComhAuthor Commented:
Thanks for the definitive answer to prevent me from chasing something that isn't do-able.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now