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.