How do I get a list of tables, field names, lengths, types?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A developer needs the specs of my Inventory database (fields contained,
names, lengths, type (txt, num, ysn, etc). And does not want it typed into a
word document. There must be some simple utility that exports this
information in a table or spreadsheet format, can someone help me with where
to find it?
 
Try using TOOLS - Analyze - Documentor and selecting your table and the
options you want. When the report runs then click on the "W" icon and select
'Analyze with Excel' to save as excel file.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Field Data Type for Linked Tables 8
Document .mdb Table Fields, Type, Size 2
How do I find maximum length of data in each field 6
Access Scan a UPC on a txtfield on mainform & add to subform Please Help! 1
Export table structure information 2
Print of multiple documents of diffent type from access 3
Export a query into a delimited txt 2
How do I keep leading zeros and remove the decimal point when expo 2

Back
Top