I try to export a table in a access database to sharepoint 2007. All related tables are automatic exported to SharePoint as lists. SharePoint creates lookup fields for each relation. Under the export I got the following error:

there was an error mapping lookup columns. lookup contains values that do not exist in the related table

enter image description here

After this error, the export will do a rollback and removes all the exported tables in sharepoint.

1 Answer 1


the problem was, there were some blank values at a foreign key column. I set some default value. Now it works fine.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.