Hi,

 I have a user requirement to get the SharePoint 2007 list column as look up in SharePoint 2013 list. is it possible to do, if yes please suggest a solution to get it done.

Thanks in advance.

you can use SPService to get data for a column from sharepoint 2007.

Thanks for the reply Bhism Narayan.

You mean i have to use SPService in my SP2013 site and is able to get column value from 2007  site ?

Please give some more details.

Hi Shiju,

From your description, my understanding is that you want create a lookup field in SharePoint 2013, and the values of the lookup field come from SharePoint 2007 list column.

Based my test, I could not create a lookup field in SharePoint 2013 and get values from SharePoint 2007. I suggest that you could create a list in SharePoint 2013 as the source list in SharePoint 2007, and create timer job to update items from SharePoint 2007 to the list in SharePoint 2013. At last, you could create the lookup field and get data from the list in SharePoint 2013.

Please refer to this article below about how to create timer job:

http://www.codeproject.com/Tips/634208/Create-and-Deploy-Custom-Timer-Job-Definition-in-S

This article below shows that how to create and update items in SharePoint list:

https://msdn.microsoft.com/en-us/library/office/ee539976%28v=office.14%29.aspx?f=255&MSPPError=-2147217396

Best Regards,

Vincent Han

Thanks for the reply Vincent.

 Its a good solution, but We need immediate reflection in 2013 sites while making changes that are made in 2007 site. Timerjob will showcase the changes after the scheduled execution only. So we need a live connection in between the two sites, like BDC or any service. 

Hi Shiju,

Based your requirement and my last reply, you could create Event Receivers that assign to the list in SharePoint 2007. And the Receivers contains the code to update the items in SharePoint 2013 list if you have any changes in SharePoint 2007 list.

Please refer to this article about SharePoint 2007 Event Receivers:

https://msdn.microsoft.com/en-us/library/ff713710(v=office.12).aspx

http://aarebrot.net/blog/2010/08/creating-custom-list-event-receivers-in-sharepoint-2007/

And refer to my last reply to update the list items in the SharePoint 2007 Event Receivers.

Best Regards,

Vincent Han