Basically I'm trying to migrate my SP2007 site to SP2010 for Which I migrated all the list, Libraries and worklfows everything. Now I want to update my data in 2010 environment for which I just want to export data from 2007 List and import data into new 2010 site list.
I've tried to export and import using excel but I was unable to do so because it was exporting only that data which defined in a view and then I created a new View "all Requests" with all columns selected and then I tried the same but it was not able to open in excel file as the files says unexpected error has occurred.
Now can any one help me around with this data migration. Is there any other way around to migrate data. Because excel is unable to open/read my data
I've migrated my list using the following link