access and sharepoint

Question

how can I export data from access to SharePoint ? What is the connection between them?

Answer 1

Hi @Vafanejad, Donya
SharePoint is basically a document collaboration and management tool proposed by Microsoft. This content management system is comprised of a set of technologies having compact integration with Office 365 and convenient document management aptitudes.

One can easily use Access 2010/2013/2016/2019 and Access services on SharePoint to create web database applications. Ultimately this application will help you to perform the following tasks.
1.To have safe and secure access to your data.
2.Share Access database data all over the internet or to an organization.
3.To make a database application that doesn’t require any MS Access application to use.

Access 2010/2013/2016/2019 and Access Services gives a platform to make databases that you can use on the SharePoint site. Using an Access database and Access services you can design/publish a web database. Users who are already having an account on the SharePoint site can make use of the web database in a web browser.

Per my research, we could move Access database data to SharePoint Online as following:

Use the Export Tables to SharePoint Wizard:

1.On the Database Tools tab, in the Move Data group, click SharePoint. This option is only available if your database is saved in the .accdb file format.

2.Follow the steps in the Export Tables to SharePoint Wizard, including specifying the location of your SharePoint site.
To cancel the process, click Stop.

3.On the last page of the wizard, select the Show Details check box to see more details about the migration.

This wizard page describes which tables have been linked to lists and provides information about a backup location and the URL for your database. It also provides a warning if some migration issues were encountered and provides the location of a log table where you can see more details about the issues.

4.Click Finish when the wizard completes its actions.

If the wizard displays a warning, you should review the log table and take any actions necessary to ensure that your data was migrated successfully. For example, certain fields may not be moved or may be converted to another data type that is compatible with a SharePoint list.

For more information, you could refer to:
https://support.microsoft.com/en-us/office/import-link-or-move-data-to-sharepoint-65bf7b03-74bf-445c-959a-24b7a401ddee

You could also check if you could publish an Access database to SharePoint Online site as described below:
https://support.microsoft.com/en-us/office/build-and-publish-an-access-database-to-sharepoint-e68bf007-410c-43b2-bf21-322ddbcf5411

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thanks @Yi Lu_MSFT

how can I automate the export function from Microsoft Access to SharePoint? because I think exporting too often may cause duplication in SharePoint list, right? I want to use Microsoft Flow to automate triggers to export access data into SharePoint. Thanks