# Migrate List Items from SharePoint 2007 to SharePoint 2013 with Access 2016

One of our Clients has finally decided to drop MOSS 2007 (SharePoint 2007) and actually move to SharePoint 2013. While…

blog

12 May 2016 es

![Migrate List Items from SharePoint 2007 to SharePoint 2013 with Access 2016](/wp-content/uploads/2016/05/SharePoint_2013.png)

[Ver imágenes (10)](#pf-content-image-1-0)

One of our Clients has finally decided to drop **MOSS 2007 (SharePoint 2007)** and actually move to **SharePoint 2013**. While there are several ways to do migration we decided that the old setup is so bad and confusing that's it's much easier to create Clean **SharePoint 2013 Foundation** and actually simply copy all the files to new **SharePoint**. While copying the files and folders was a breeze copying a **List Items** with **attachments** is a quite different story. Fortunately there's an easy way to do this with **Microsoft Access 2016** (2013 works too).

### 🔹 Export SharePoint 2007 data to Access 2016

Open **Microsoft Access 2016**

[!\[Microsoft Access 2016 start screen\](/wp-content/uploads/2016/05/img_573493e7a185d.png)](/wp-content/uploads/2016/05/img_573493e7a185d.png)

Choose **Blank desktop database **type in name of the database and press **Create**

[!\[Access 2016 blank desktop database creation screen\](/wp-content/uploads/2016/05/img_573493f92fee8.png)](/wp-content/uploads/2016/05/img_573493f92fee8.png)

Switch to **External Data **tab, choose **More** and use **SharePoint List**

[!\[Access 2016 External Data menu with SharePoint List option\](/wp-content/uploads/2016/05/img_57349443b40fb.png)](/wp-content/uploads/2016/05/img_57349443b40fb.png)

On next screen type in place where you have **List Libraries** and make sure to choose **Import the source data into a new table in the current database**. Press **Next** to proceed.

[!\[Access import wizard for SharePoint list data into a new table\](/wp-content/uploads/2016/05/img_573494a38e32b.png)](/wp-content/uploads/2016/05/img_573494a38e32b.png)

After pressing **Next **list of potential data is displayed. Choose the ones you're interested in and press **OK**

[!\[Access list selection screen for SharePoint import\](/wp-content/uploads/2016/05/img_5734957ddb694.png)](/wp-content/uploads/2016/05/img_5734957ddb694.png)

Now Access may take some time to process import from **SharePoint 2007** to **Access 2016**. At the bottom of the screen progress should be shown.

![Access import progress for SharePoint 2007 list data](/wp-content/uploads/2016/05/img_573495de45e2e.png)

**Access** during move may become **unresponsive**. If you've chosen multiple **Lists** it may need to fill progress bar multiple times. Just give it time. After it's done click **Close**.

[!\[Completed Access import dialog for SharePoint lists\](/wp-content/uploads/2016/05/img_5734a9e1a36ec.png)](/wp-content/uploads/2016/05/img_5734a9e1a36ec.png)

### 🔹 Import Access 2016 data to SharePoint 2013

Now that we have exported MOSS 2007 List Data with attachments we need to import these data back to SharePoint 2013.

[!\[Imported SharePoint lists shown in Access\](/wp-content/uploads/2016/05/img_5734ab45cd988.png)](/wp-content/uploads/2016/05/img_5734ab45cd988.png)

Now for every List on the left side under **All Access Objects** we need to do the **Export** procedure. On the same **External Data** tab under **Export** Group once again we click **More** and choose **SharePoint List.**

[!\[Access export menu with SharePoint List option\](/wp-content/uploads/2016/05/img_5734abd599137.png)](/wp-content/uploads/2016/05/img_5734abd599137.png)

New **Export Wizard** shows up where you point it to new **SharePoint 2013** url, optionally give new name to the list if it's supposed to be something different then it was and press **OK**.

[!\[Access Export Wizard for a SharePoint 2013 list\](/wp-content/uploads/2016/05/img_5734ad4c0285b.png)](/wp-content/uploads/2016/05/img_5734ad4c0285b.png)

That's it! During Exporting there will be a small progress bar showing how things are doing.

[!\[Access export progress dialog for SharePoint 2013 list\](/wp-content/uploads/2016/05/img_5734adc080cac.png)](/wp-content/uploads/2016/05/img_5734adc080cac.png)

It will even open up on the site when it's done if we leave **Open the list when finished. **

## Proyectos relacionados

Proyectos que encajan con las etiquetas, categorías y contenido de este artículo.

[Todos los proyectos](/es/proyectos/)

Buscando proyectos relacionados...

[Volver al blog](/blog)

## Artículos relacionados

- [Exchange 2013 integration with SharePoint doesn’t work](/es/blog/exchange-2013-integration-with-sharepoint-doesnt-work/)
- [Check an API write after a PowerShell timeout](/es/blog/verify-uncertain-api-outcomes-powershell/)
- [Inspect and convert mixed Office archives with PSWriteOffice](/es/blog/inspect-and-convert-mixed-office-archives-pswriteoffice/)

<!-- PowerForge markdown artifact sha256:C2301CFD64CFC02FF1A1AB449A243510D84E168C796E9234A02EABEB89176C6C -->
