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.
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.
You should now have your List duplicated to your SharePoint 2010 site.