Importing Lists from SharePoint 2007 to SharePoint 2013 via Excel RRS feed

  • Question

  • Hi,

    We are migrating from a SharePoint 2007 server to a SharePoint 2013 server. Not all of the content is coming over, so we are just migrating only those things we need.

    We have a list that we can export from SharePoint 2007, and it will export out the ID of the individual items. We need to be able to import that list with the same IDs for each line item. We need to do this because we have an external Access database that is linking to those items via some method.

    When we try the export from SharePoint 2007, we get the Title and ID (the only two fields in there), but when we import them into SharePoint 2013 (Import Excel into List), we end up with 3 columns -- ID, ID1, Title. ID1 is the ID from the SharePoint 2007 list, but I need it to create the ID in 2013 to match the same in 2007.

    Any help on this would be appreciated

    Tuesday, March 15, 2016 3:05 PM