export list of field names

[CuriousMark]

Is there a way to use VBA to export to a text file a list of the Field Names
and corresponding Data Types for all the fields in a given table?

 

[Allen Browne]

The code in this link shows how to loop through the Fields of a TableDef to
get the field names and data types:
http://allenbrowne.com/func-06.html

To export to a text file, use Open and Print #.

 

[CuriousMark]

Thanks very much. That's perfect.
CM

The code in this link shows how to loop through the Fields of a TableDef to
get the field names and data types:
http://allenbrowne.com/func-06.html

To export to a text file, use Open and Print #.