import data to the lookup picker field

Apr 27, 2011 at 5:21 PM
Edited Apr 27, 2011 at 5:24 PM

I'm going to import more than 10000 records to a sharepoint list, in which I used the lookup picker. But when I try to copy and paste the data from Excel to the data sheet view, an error msg came up "the cell (picker field) is read only".

Can some one help me? Thanks, yi

May 3, 2011 at 3:48 PM

Unfortunately SharePoint does not the support the data sheet view for custom field types. You have to do the import with PowerShell (SharePoint Object Model).

Bye, Christian