access and sharepoint

Vafanejad, Donya 26 Reputation points
2022-02-03T17:11:23.307+00:00

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

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,617 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,668 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,798 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yi Lu_MSFT 17,456 Reputation points
    2022-02-04T02:09:23.463+00:00

    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.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Vafanejad, Donya 26 Reputation points
    2022-02-04T22:59:29.84+00:00

    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

    0 comments No comments