---
title: "How You Can Import A Sharepoint List in MS-Access?"  
description: "How You Can Import A Sharepoint List in MS-Access?"  
author: "Sanjay Goenka"  
published: 2022-03-31  
canonical: https://answers.mindstick.com/qa/96634/how-you-can-import-a-sharepoint-list-in-ms-access  
category: "troubleshooting"  
tags: ["troubleshooting", "ms-access"]  
reading_time: 1 minute  

---

# How You Can Import A Sharepoint List in MS-Access?

How You Can [Import](https://www.mindstick.com/blog/294/how-to-import-or-export-sql-server-table-data-in-ms-excel-sheet-using-c-sharp-code) A [Sharepoint](https://www.mindstick.com/forum/320/sharepoint-server-displays-a-blank-page-after-installing-sharepoint) List in MS-[Access](https://www.mindstick.com/articles/12994/how-foreigners-can-access-blocked-websites-in-china)?

## Answers

### Answer by Hitesh Vohra

**Steps to Import A Sharepoint List in [MS](https://answers.mindstick.com/qa/96642/is-ms-paint-good-with-a-drawing-tablet)-Access:**

- The **Get External Data – SharePoint Site** dialogue box appears when you click **Access.**
- Specify the source site's address in the wizard.
- Click **Next** after selecting Import the source data into a new table in the current database.
- Select the lists you want to import from the list displayed by the wizard.
- Note You can link to SharePoint libraries, but you can only add content to those libraries in SharePoint.
- Select the view you want for each selected list in the Items to Import column.
- Which data is imported for lookup columns in the selected lists is controlled by the check box labelled Import display values instead of IDs for fields that look up values contained in another list.
- Click **OK**

## \

**Read More: [Why does art drawn with MS Paint always look so bad?](https://answers.mindstick.com/qa/96640/why-does-art-drawn-with-ms-paint-always-look-so-bad)**


---

Original Source: https://answers.mindstick.com/qa/96634/how-you-can-import-a-sharepoint-list-in-ms-access

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.