Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I am inputting a list in Sharepoint that has a lookup to it. For example I have all the client data in excel, I need to import this in Sharepoint and then convert the client association from a multi line text or single line txt to lookup.

Example client A has three subcompanies called Client B and Client C and Client D

I have brought these three sub company names in a text field that I would like to use to populate a lookup field that will show under client A. A relates to company etc.

I have tried doing this through the access database and other import methods and seem to be stumped.

I would manually do the connections myself however the list is over 9000 and there are more than one field of this nature that will need to reference other columns and lists on the site.

share|improve this question
add comment

2 Answers

I think most in this scenario import the values as palin text and create their choice columns with the proper values. Then they arrange the text and choice fields beside each other in a view and toggle over to datasheet voew and do a copy/paste, then delete the text colummn.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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