Copy list of tables to Excel

  • Thread starter Thread starter deeds
  • Start date Start date
D

deeds

Hello...
Can someone tell me how one would go about copying the table list within
the "Tables" tab in Access and be able to paste those table names into Excel.
I would think this would be possible. I want to create an Excel file that
lists out all of the tables, queries, etc that are in the database. Thanks
in advance.
 
What will having a "list of table names" in Excel allow you to do?

Have you looked into the Tools | Analyze | Documenter function that will
generate printed output of these kinds of things?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks...that gives good info, however, all I want is a list of all tables, a
list of all queries...then I can show graphically which queries make which
tables, etc.... Let me know if you have another option. Thanks.
 
Create a new query:

SELECT MSysObjects.Name, MSysObjects.Type
FROM MSysObjects;

You can set criteria on the Type field to return only local tables, linked
tables, queries, etc.
Then export it to Excel.
 
Thanks! Works good. Now to take it another step. It would be nice to be
able to identify between make table, select, append etc.. queries. Let me
know if that is possible....thanks again!
 
Back
Top