How do I export Access to a SharePoint list?

How do I export an Access database to a SharePoint list?

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.

How do I import Access table into SharePoint list?

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.

How do I connect an Access database to a SharePoint list?

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 share Access to a SharePoint list?

On the permissions page for the list, on the Edit tab, click Grant Permissions. Type the name of the group or the individual you want to grant access to in the Users/Groups box. Choose the level of permissions you want the group or individuals to have. Click OK.