Export Fields in Design View of Access to Excel

  • Thread starter Thread starter Dano
  • Start date Start date
D

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
 
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
 
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 -
Click to expand...

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
 
Back
Top