Support

Sign in

Sign in with Microsoft

Sign in or create an account.

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Introduction to importing, linking, and exporting data in Access

Applies To

Access for Microsoft 365 Access 2024 Access 2021 Access 2019 Access 2016

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

Import or link to data in another Access database
Import database objects into the current Access database
Import or link to data in an Excel workbook
Import or link to data in an SQL Server database
Link to or import data from an Azure SQL Server Database - Access 2016 and newer versions only
Import or link to data in a text file
Import or link to data in a SharePoint list
Link to or import from dBASE
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 or link to contacts from an Outlook address book
Link to a Data Service
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

What else should I know?