We have a list in sharepoint 2007 that we need to move to another site which is based on sharepoint 2010.
what's the best and fastest method?
thanks in advance
the best way is to export the list to a spreadsheet in 2007 and then import that xslx file in 2010. I found this article very useful:
by the way, I faced a problem when exporting to excel if the site is using forms based authentication with the error message: "Excel Cannot access sharepoint list"
one more thing, Make sure you have the fields visible in the view before you export to spreadsheet since non-visible fields will NOT be included.
If you read this article by Thao Nguyen at Bamboo Solutions you will find 4 different methods for migrating a list from SharePoint 2007 to SharePoint 2010. My preferred method is number 1:
Method 1 - Migrate a single list from SharePoint 2007 to 2010 using a list template
This works well for me becacuse I can write a bit of powershell to automate most of the process.
For upgrading the list templates (being migrated from MOSS 2007 to SharePoint 2010) either you have to manually upgrade them by hand or using some PowerShell to upgrade them. Even if you upgrade them using PowerShell, there is no way to automatically upload (the upgraded template) them back to the site collections where they belong to:
I have done the PowerShell which performs the following 4 tasks:
Full code can be downloaded from CodePlex: https://upgradelisttemplates.codeplex.com/
Technet Gallery: http://gallery.technet.microsoft.com/Upgrade-List-Templates-0b86f443
I just had good success using Microsoft Access to move a list from a SharePoint 2007 site to a SharePoint 2010 site.