Export Fields in Design View of Access to Excel

[Dano]

Is there a way to take the fields in the Design view of a MS Access
table (Field Name, Data Type and Description) and export that or copy
and past it to excel?

So for example, as we create our tables, we have

Field Name
Owner

Data Type
Text

Description
Owner of the Contact

How could I export that...not the actual data in those fields but the
field properties essentially?

Did that make sense?

Dano

 

[Guest]

Curious...why would you want to do that?

You can get these field properties through VBA and then use some kind of
mechanism to output them to Excel.

Steve

 

[Dano]

Curious...why would you want to do that?

You can get these field properties through VBA and then use some kind of
mechanism to output them to Excel.

Steve












- Show quoted text -

We want to make sure that all the data elements of a DB are being
captured by a contractor. We need to audit, essentially, what they
are capturing.

I don't know how to use VBA...ideas, help?

Dano