Type mismatch between the columns

Nov 8, 2010 at 7:45 PM
Edited Nov 8, 2010 at 7:46 PM

i get this error when i try to import the data 

Type mismatch between the columns even if the columns have the values.. 

the columns is a lookup column

Dec 2, 2010 at 5: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.

Dec 2, 2010 at 2:06 PM

it did work... :) cheers

but then these are stuffs which needs custmization in the dev perpective right...

hope to see in the new versions