I need extract description field from access data base - metadata

  • Thread starter Thread starter Gloria
  • Start date Start date
G

Gloria

I need a way to extract just the key fields "field names",
and description from my access database. I need the meta
data not the values of the fields for documentation. The
documentation tool in Access gives too much information.

TIA,
Gloria
 
Gloria,

Paste the following code in a module, change
the "TableName" to your actual table name and the file
path and name to whatever you want it to be and run. It
will make a text file with what you want.
If you want to do something different (get the data in an
Access table? Get other / more field data?)I can help you,
just notify me by e-mail once you've posted or I might
miss it.

HTH,
Nikos

Sub get_filed_info()
Dim db As Database
Dim tbl As TableDef
Set db = CurrentDb()
Set tbl = db.TableDefs("TableName")
Open "c:\temp\fieldinf.txt" For Output As #1
For Each f In tbl.Fields
Print #1, f.Name, f.Properties("Description")
Next
Close #1
End Sub
 
Back
Top