Use the Linked Table Manager in Access to manage external data sources and to refresh, relink, edit, or delete linked tables due to changes to the data source location and table name or schema.

Use the Linked Table Manager in Access to manage external data sources and to refresh, relink, edit, or delete linked tables due to changes to the data source location and table name or schema.

Identify the tables or views that you want to link to or import, and uniquely-valued fields for linked tables. You can link to or import more than one table or view in a single operation.

Identify the tables or views that you want to link to or import, and uniquely-valued fields for linked tables. You can link to or import more than one table or view in a single operation.

In Office 365, you can use this dialog box to refresh, relink, add, edit, search, and delete linked tables, but you cannot export information to Excel. In Access 2016 and later, the dialog box is much simpler, but you can export information to Excel.

All linked data types are connected to a data source, but for some data types, it's more important to ensure that the data is up to date as possible. While you can always refresh manually, you can easily set some data types to refresh automatically with Data Types Refresh Settings.

Microsoft Data Access Objects (DAO) is the native programming object model that lets you get at the heart of Access and SQL Server to create, delete, modify, and list objects, tables, fields, indexes, relations, queries, properties, and external databases.

The refresh process updates the existing data in a datasheet or form, and doesn't reorder records, display new records, or remove any deleted records or records that no longer meet specified criteria.

When you create a table in Excel and then generate a linked table in the Power Pivot workbook, the tables are linked by name, and have identical data in them. However, the following changes to the Excel table can cause errors:

Automatic Refresh is new and enabled by default, so these errors may be appearing even if you haven't tried to refresh anything. Check below for the circumstances that cause these refresh errors and what you can do to mitigate them.