How To Export A List Of Linked Tables From Access To Excel

Do you know the new Access 2016 has a new feature with which you can easily export your linked Access tables to Excel?

This feature is really very helpful if you are working on a complex database with links to many different data sources. Such list might also be contained in any documentation you might write for the database.

Steps To Export Linked Tables From Access To Excel


1

Click to the Linked Table Manager button in the ribbon from the External Data tab.

2

Make selection for the table you want to export and click Export To Excel.

You can tap to the ok option, to refresh the tables first, before running the export. This will clarify that the information your export is correct.

3

Assign name to the File and click to the Save option.

4

To close the linked table manger, click Cancel. If you tap to the ok option to update all tables first, this button will read close.

5

Now open the excel file to check it's content.

You may notice that the excel file is already blinking in the windows taskbar. In such case, just simply click it to open the Excel file.