One of the most useful features of Access is its ability to interface with data from many other programs. In fact, it’s difficult to summarize in a single article all the ways in which you can move data into and out of Access.
What do you want to do?
Import or link to data
-
Link to or import data from an Azure SQL Server Database - Access 2016 and newer versions only
-
Link to or import data from Salesforce - Microsoft 365 Apps for enterprise, Office 365 Enterprise E3, and Office 365 Enterprise E5 only
-
Link to or import data from Dynamics 365 - Microsoft 365 Apps for enterprise, Office 365 Enterprise E3, and Office 365 Enterprise E5 only
-
Import data from an Access database into an Access web app -?Access 2016 only
-
Import Access 2.0 and Access 95 databases into current versions
Export data
-
Export Access web app tables to SharePoint - Access 2016 only
-
Export Access web app tables to an Access desktop database - Access 2016 only
