DB Table Design

  • Thread starter Thread starter PatRyan
  • Start date Start date
P

PatRyan

Hope this is an easy question.... Is there a way to copy the access db table
design (field name, data type, etc) into Excel?

Thanks!
 
Options:

1) use the Documentor (in 2003: Tools>Analyze>Document) to create a report
and use that to export to Excel. You would probably need to do a fair amount
of clean up on the results in Excel (delete rows with page headers &
footers, etc.). You might play around with the various options (export
report directly to Excel vs. export report to a text file and then import
text file into excel). I've found that different methods produce results
requiring significantly different amounts of clean-up (and it varies from
report to report so there is no "best" method for all Access reports.)

2) write a vba routine (in either Excel or Access) that would loop through
the DAO heirarchy (tabledefs, fields, properties, etc.) and list the ones
you want. I have my own Excel "utility" that will produce some rudimentary
documentation for any mdb file. It comes in very handy.

3) Look for a 3rd party tool to do what you want.
 
Pat

Are you talking about a single table or all the tables in an Access database
file (.mdb)?

And then, why? What will having this in Excel allow you to do? I ask, not
out of curiosity, but because knowing what you want to accomplish may
suggest alternate approaches...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
That works...thank you!!
--
Pat


George Nicholson said:
Options:

1) use the Documentor (in 2003: Tools>Analyze>Document) to create a report
and use that to export to Excel. You would probably need to do a fair amount
of clean up on the results in Excel (delete rows with page headers &
footers, etc.). You might play around with the various options (export
report directly to Excel vs. export report to a text file and then import
text file into excel). I've found that different methods produce results
requiring significantly different amounts of clean-up (and it varies from
report to report so there is no "best" method for all Access reports.)

2) write a vba routine (in either Excel or Access) that would loop through
the DAO heirarchy (tabledefs, fields, properties, etc.) and list the ones
you want. I have my own Excel "utility" that will produce some rudimentary
documentation for any mdb file. It comes in very handy.

3) Look for a 3rd party tool to do what you want.
Click to expand...
 
Hi Jeff, I believe my business user is asking to do it for a specific table,
but I imagine it would also be helpful to be able to do it for all or
selected multiple tables. Her intent is to use the information for
documentation and sharing the information to non-db users. Thanks for any
additional help you can offer!
 
Putting something like this in Excel might imply that someone will be
manipulating it. Would a "picture" do? Access has a "Documenter" function
(as mentioned elsewhere), and there are third party documenter applications.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top