Access 2013 - How to Extract Inforamation About Linked Tables?

[kc27]

I came across instructions to use the Linked Table Manager to export information about linked tables to Excel. However in Access 2013, there is no "Export to Excel" button in the Linked Table Manager. Is there another way I can pull the information about the linked tables?



Thanks in advance for any ideas on this.

[ranman256]

export to excel is not in the linked table manager, it is in EXTERNAL DATA tab of main toolbar.
external data, excel.

if you use a macro ,it will allow you to fill in the parameters needed.

[kc27]

Thanks for the reply. Am I misreading your instructions? It looks like the External Data tab is used to export data from tables. I am looking for something different. I don't want the data in the table, only information about the linked table itself. Is there a way to do that?

[Micron]

Database Tools (ribbon) > Database Documenter?
Choose the table(s) or other objects you want to report on. Note: you'll get a lot of info about every object, so maybe choose one as a test first. I can't recall for certain what you get about linked tables. Maybe expect less for ODBC type tables as opposed to Access tables.