Manage appointments, plans, budgets — it’s easy with Microsoft 365.​

Export linked data source information to Excel

Have you ever wanted to get a nice list of all the linked data sources from your Access database application exported into Excel? If you are working on a complex Access application, for example, that includes links to many different data sources, it can be helpful to have a nice list of all the various data sources and their types. This exported list can be especially helpful if you are working on an Access application you did not originally design. With Access 2016 and newer versions, you'll find this task much easier using functionality built into the Linked Table Manager dialog.

Open the Linked Table Manager dialog in Access 2016 or newer versions by clicking External Data > Linked Table Manager. Select the linked data sources you want to list and then click Export to Excel.

The linked table manager dialog in Access with the Export to Excel button selected.

Access prompts you for a location to save the Excel workbook. After you provide a save location, Access displays the linked data sources information in the new workbook. You'll see the name of the linked data source, its source information, and the data source type.

Excel workbook displaying linked table information from Access

Note: The Linked Table Manager dialog is not available when designing Access web apps.

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.