How to create SharePoint list from access data?

Question

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

Can an Access database be used in 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 export Access to a SharePoint list?

To export your Access web app tables to SharePoint lists, complete the following steps.1Open your Access web app in your web browser, and then click Settings > Export to SharePoint Lists.2You'll see a confirmation message asking if you're sure you want to export the tables.Export Access web app tables to SharePoint - Microsoft Support

How do I create a SharePoint site in Access?

Go to Microsoft 365 admin center -> Users -> Active users -> Select the user -> Roles -> Give this user global administrator permissions. Then the user can go to Microsoft 365 admin center and SharePoint admin center to create sites and Microsoft 365 groups.

Expert · Answer