Road to Ironman Arizona 2011

Alex says:

Hi there,

I am emailing you regarding a tricky issue, I hope you could help me in it.

I am working on a project and dealing with so many lists, and of course there are so many “Lookup Fields” between those lists.

Now I want to transfer these lists to a new environment which already has data and I have no idea how to handle that because I don’t want to override the data and of course I want to keep the connections between these Lookup Fields, How can I do that ???

Somehow my problem is pretty close to this entry:

http://objectmix.com/sharepoint/294151-moving-lists-one-sharepoint-server-another.html

So far, the only way I know how to do that is to export the data to Excel and use Access 2007 to import again so its about how to create Lookup fields with the APIs. I have actually tried several times but never gotten around to do it in another better way, do you have any idea or another option/suggestion or code make me able to handle this issue?

I look forward to hearing from you soon please!

Sincerely,
–Alex