SharePoint Document Issues

How to Link a SharePoint List to Microsoft Access and Filter Records

Adam Davis Oct 10, 2026 868 views

Question details

The user needs to connect Microsoft Access directly to a SharePoint list to query and report on data filtered by specific locations.

How to Link a SharePoint List to Access and Filter Records by Location

Product: Microsoft Access and SharePoint
Device & OS: not provided
Scenario: Managing and querying centralized SharePoint data within Microsoft Access without maintaining separate local copies.
Observed behavior: The user wants to establish a linked table between Access and SharePoint and apply location-based filters for building forms and reports.

Before you start

Ensure you have the correct URL for your SharePoint site and verify that you possess the necessary read or edit permissions to access the list data.

Solution 1Recommended

Linking the SharePoint List and Creating Filtered Queries in Access

Use the built-in External Data feature in Microsoft Access to create a live-linked table to your SharePoint list and build filtered queries.

By linking your SharePoint list rather than importing it, Microsoft Access maintains a live connection to the source data. This allows your queries, forms, and reports to always display the most current information without requiring manual updates.

Navigate to External Data

Open your database in Microsoft Access. On the top ribbon, go to the 'External Data' tab and click on 'New Data Source'.

Connect to SharePoint

From the dropdown menu, select 'From Online Services' and then click on 'SharePoint List'.

Enter Site Details

In the dialog box, input your SharePoint site URL. Choose the option 'Link to the data source by creating a linked table' and click 'Next'.

Select the Target List

A list of available SharePoint lists will appear. Check the box next to the specific list you want to link to Access and click 'OK'.

Build Location-Filtered Queries

Go to the 'Create' tab and select 'Query Design'. Add your newly linked SharePoint table. Drag the 'Location' field into the query grid and type your criteria (e.g., 'North', 'South', 'East', or 'West') in the Criteria row. Save the query to use it as a record source for your forms or reports.

Linking the SharePoint List and Creating Filtered Queries in Access

Live Data Synchronization: Because the table is linked, any data modifications you make within the updatable Access query will automatically sync back to the SharePoint list, provided you have sufficient permissions.

Free Microsoft Office alternative

Looking for a Lightweight Office Suite? Try WPS Office

While Microsoft Access is a specialized tool for complex database management with SharePoint, you might need a fast, reliable, and cost-effective alternative for your daily document, spreadsheet, and presentation needs. WPS Office offers excellent compatibility with standard Office formats without the heavy subscription fees.

1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install and Launch: Run the installer, follow the straightforward on-screen instructions, and launch the WPS Office suite.
3. Open Your Office Files: Simply drag and drop your existing Microsoft Office documents into the WPS workspace to continue editing with full formatting compatibility.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight installation that runs smoothly on both older and modern PCs.Includes built-in PDF editing, converting, and merging tools for comprehensive document management.Familiar, tabbed user interface for a seamless transition from other Office suites.

microsoft office alternative - wps office

Frequently Asked Questions

Do I need to manually refresh the linked SharePoint list in Access?

Linked tables in Access generally maintain a live connection to SharePoint. However, if the network drops or structural changes (like new columns) occur on the SharePoint list, you can manually refresh the link by right-clicking the table and selecting 'Linked Table Manager'.

Can I edit SharePoint data directly from the linked Access query?

Yes, as long as the query is updatable and you have the appropriate edit permissions on the SharePoint site, changes made in Access will sync directly back to SharePoint.

Why is the SharePoint List option missing in my Microsoft Access?

This option might be missing if your Office installation is corrupted, if it requires an update, or if your organizational IT policies have disabled connections to external online services. Try repairing your Office installation or contacting your IT administrator.

Can I use the filtered queries as data sources for Access reports?

Absolutely. Once you create and save your location-filtered query, you can easily select it as the 'Record Source' from the Property Sheet when building new forms or reports in Access.

Document & File Issues