How to Integrate Microsoft Access with a SharePoint List: 1-Min Guide

How to Integrate Microsoft Access with a SharePoint List

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to connect Microsoft Access to a SharePoint List in minutes.

Quick summary

Integrating Microsoft Access with a SharePoint List lets you link or import SharePoint data directly into an Access database using the built-in External Data import wizard. This step-by-step process requires only a SharePoint site URL and a few clicks inside the Access ribbon.

Steps

Navigate to the top menu bar in Microsoft Access and click External Data.
Click the More option located under the Import & Link section.
Select SharePoint List from the list of available data source options.
Enter the URL of your SharePoint site into the input field and choose your preferred database location.
Click Next to connect to your SharePoint site, then select the specific list you want to integrate with your Access database.

📌 Why this matters

Connecting Microsoft Access to a SharePoint List allows teams to work with live, collaborative SharePoint data directly inside a familiar Access database environment. This integration eliminates manual data exports by letting users import or link SharePoint lists in just a few steps, keeping records synchronized across platforms. For organizations already using Microsoft 365, it is a fast, no-code way to combine the querying power of Access with the real-time data sharing of SharePoint.

Your product deserves an interactive demo

Start free

How to Integrate a Microsoft Excel Database with Excel

How to Integrate Google Calendar with an MS Access Database

How to Integrate Google Sheets with an MS Access Database