Anonymous
Anonymous Asked in Cars &Transportation · 2 weeks ago

Can an Access database be used in SharePoint?

Contents
  1. How do I add an Access database to SharePoint?
  2. What database works with SharePoint?
  3. How do I link an Access database to a SharePoint list?
  4. How do I export an Access database to SharePoint?
Access 2010 and Access Services provide a platform for you to create databases that you can use on a SharePoint site. You design and publish a web database by using Access 2010 and Access Services, and people who have accounts on the SharePoint site use the web database in a web browser.


How do I add an Access database to SharePoint?

Access opens the Get External Data – SharePoint Site dialog box. In the wizard, specify the address of the source site. Select the Import the source data into a new table in the current database option, and click Next. From the list that the wizard displays, select the lists that you want to import.

What database works with SharePoint?

Databases for SharePoint Server 2019 can be hosted in Microsoft SQL Server 2016 and Microsoft SQL Server 2017. Databases for SharePoint Server 2016 can be hosted in SQL Server 2014 Service Pack 1 (SP1) and SQL Server 2016.

1On the External Data tab, select More > SharePoint List.2Specify the SharePoint site.3Select Link to the data source by creating a linked table, and then click Next.4Select the list you want to link to, and then click OK.

How do I export an Access database to SharePoint?

Follow these steps:1From your database, right-click on the table on the left pane and select Export.2Select SharePoint list from the drop-down menu.3In the Export data to SharePoint list window, enter the URL of your SharePoint site and specify the name for the new list.4Click OK.

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours