I have a SharePoint 2007 list that I want to copy over to an existing SharePoint 2010 list. Both of them have the exact same columns.
What is the best way to do this?
I tried opening both of them in Access and then just copy and past the records but it does not want to work.
I even exported the 2007 list to Excel and then tried to import the Excel file to the 2010 list and that did not want to work as well.