title: combine multiple sharepoint lists into one
body: <p>I'm working with SharePoint 2007 and a group has asked me to help with managing their sites. They set up multiple sites (one for each team = 50 or so teams >_&lt;) and each team has their own copy of the same list created from the same template. </p>
  
  <p>Recently they decided that collecting the data from 50 different sites is too much and want to combine all the lists into one at the top level but they don't want all that data left behind on the old lists (1 per site) they want it all moved into the new list that will also use the same template to be created. </p>
  
  <p>I tried exporting one of the sub-site's lists to Excel (2010) and copying it over into the new master list's empty exported to excel list and then using the "Export Table to SharePoint List..." option. Each time I try, I get an error "An unexpected error has occurred. Changes to your data cannot be saved."</p>
  
  <p>I thought this might have to do with the Path field that shows up in the Excel spreadsheet versions of the list data so I modified it to what the new master list should have but no luck. </p>
  
  <p>Any ideas?</p>
  
  <p>Thanks for your help :)</p>