Migrate tables, data, database to SharePoint online

About:


This is to migrate any access data base to SharePoint sites to use it online as a web database.

You can keep using access as a front end app for the database after migration to SharePoint. However, DO NOT SAVE THE ACESS DB FILE ON OneDrive and open it from there. It will create multiple instance of the data and cause errors to the SharePoint data.

Always use the access file locally on the computer. Then upload it to OneDrive as backup after you finish working on it.

Steps:

  • Make sure that SharePoint site related to the database is created and active.
    • Set all permissions and users whom going to access the SharePoint site.
    • Copy the link to the SharePoint site
      • Open office 365 admin
      • Open SharePoint
      • On the left, click on “Sites” and “Active Sites”
      •  
      • Click on the requested site, and click on its URL
      •  
      • Copy the URL from the address bar
      •  
      • You will use it in access to migrate the database
  • You create the database on access with all the tables correctly.
    • Open the access database file
    • Click on “File”, “Account”

    • Click on “Add Services”, “Storage”, “OneDrive for Business”
    •  
    • You will need to sign in to Office 365 admin using the tenant credentials
    •  
    • It will add the SharePoint sites
    • Get back to the database file
    • Click on “Database Tools”, and “SharePoint”
    •  
    • Choose the SharePoint site that you want to migrate the database tables to
    •  
    • Click “Next” and leave Access upload the tables to SharePoint and create the lists automatically.
    • After it finishes, you will notice that all tables in access are linked tables now linked to the lists in SharePoint
    •  
    • You will need to modify the SharePoint lists to your requirements as the lists properties are different to access table properties.