How to Connect Access with Microsoft SharePoint

How to Connect Access with Microsoft SharePoint

Because Microsoft’s products are integrated into Office 365, it has become possible to link and transfer documents from one application to another. This article will discuss how to connect Access database with Microsoft SharePoint.

• Step 1: Create a SharePoint Site

  
  Log in to your Office 365 account and launch SharePoint then create a new site for your database. While filling out the information of the site, a URL will automatically be assigned for the site which you need to copy or take note of. You can also invite or add site owners and members from your organization so they can access the document in SharePoint.

• Step 2: Open Database in Access

  After creating a site in SharePoint, open the database or document in Access. You can open the document on your desktop or online via your Office 365 account. Select the tables within the database you want to upload to SharePoint or highlight all the folders if you want to upload the entire database.

• Step 3: Export Database to SharePoint

  On the top ribbon, click Database Tools and click SharePoint. A pop-up window will appear and prompt you to link the database to SharePoint by pasting the URL of the site you created. Once you click Next, Access will immediately upload or export your file to your site in SharePoint.

• Step 4: Link SharePoint List to Access

  This step is when you want to link the list from SharePoint to your database in Access. To do that, open your file in Access then under External Data, point your mouse to New Data Source. A menu will appear and from there click From Online Services > SharePoint List. Select the correct URL of the site you created, click Next, tick the boxes of all the contents you want to be available to your database, and start syncing your file from SharePoint to Access by clicking OK.