Getting list of database tables into text file

[Don Wiss]

There must be a way to get a list of a database's tables into a text file.
Any list of the tables I see in Access can't be tagged and put into the
clipboard. I'd rather not have to type in all the names. So how?

Don <www.donwiss.com> (e-mail link at home page bottom).

 

[Paul Overway]

If you only want local Access non-system tables, create a sub and run this
code. If you want all tables, comment out the If.


Dim db as database
Dim tdf as tabledef

Set db = currentdb()

For each tdf in db.tabledefs
If tdf.Attributes = 0 then
Debug.print tdf.name
End if
Next