How to Add an Access 2013 Database to SharePoint 2013 as a New List

One of the great things about SharePoint 2013 is the ability to get data from a wealth of different sources including Microsoft Word, Excel, SQL, and more. In this post, we’ll show you how to build a database in Microsoft Access 2013 and export it to your SharePoint 2013 site.

To begin, go to Start > All Programs. Open Access 2013 from Microsoft Office 2013:

Go to the New tab and select the Blank desktop database icon:

In the File Name textbox, input the name of your new database and select the location to which you would like to save it.

Click the Create button:

Access will automatically take you to a new table. Add new items and input data for the new items as needed. Please note that you can change the Table Name and Field Names as needed:

Once you have finished inputting your data, right-click Table Name and select Export > SharePoint List:

An Export Dialog box will appear.

In the Specify a SharePoint site textbox, input the URL path for your SharePoint site.

In the Specify a name for the new list textbox, input a name for the new list that you will be creating from your Access file:

Click OK.  You will have a little bit of a wait as the file is being copied over:

Go to your SharePoint site and navigate to Site Contents:

At this point, you will see that the new list which you just created in Access 2013 has now been added to your lists:

To see the content, simply click on the table’s icon and the data from your table will be displayed in SharePoint:

Want to learn more about how to collaborate with Access 2013 and SharePoint 2013? Check out our blog on How to Use the ‘Open with Access’ Feature in SharePoint 2013.