Copy List from 2007 to 2010

I’m recreating a site in SharePoint 2010 and didn’t want to create each List and Library.

I tried exporting a List from SharePoint 2007, then import into SharePoint 2010. No go.
SharePoint 2010 doesn’t like .STP files.

I opened MS Access 2010, imported my SharePoint 2007 List, then created a new List in my SharePoint 2010 site using imported 2007 List.

Like this:
In Access 2010
External Data tab
In the Import and Link section, click on More, then click on SharePoint List.
Choose the Import the source data…. option.
With your new table open, look in the Export section of External Data tab.
Click on More, click on SharePoint List, when the Export – SharePoint Site box opens, enter your destination URL and List name.
Click OK.

You should now have your List duplicated to your SharePoint 2010 site.

2 thoughts on “Copy List from 2007 to 2010

  1. i did this and its very nice way to copy, but it just doesn’t work when list contains items with folder type. all items land in main store

Leave a Reply

Your email address will not be published. Required fields are marked *