1
Vote

Type mismatch between the columns when we use Look Up columns

description

Hi,
When i use this feature to import excel data to splist which is having lookup columns its giving the error like Type mismatch between the columns.
 
Ex: I have a splist which is having Country Look up column. I mapped this Country column to the Country Column in Excel sheet.But its unable to import the Excel data as i am getting the above error.
 
Thanks,
Suresh N

comments

chrisvsfl wrote Dec 2, 2010 at 6:08 AM

I received the same error when trying to import data into a Lookup column. My work-around was:
  1. Change the required fields to off where applicable
  2. Import all the other columns
  3. Open the list in Sharepoint, Edit in Datasheet
  4. Select records in "Lookup" column in Excel (not the column, only the records in the column)
  5. Paste in the Datasheet ensuring that sorting and positioning match.

wrote Feb 21, 2013 at 11:44 PM