Exporting table configuration to excel

T

Teofilo Homsany

Hi!
If I go into design view in Access, how can I cut and paste all the
fields/information from Table Design view to Excel or something like that so
I can print it?

I really need to access each table in my DB and it would be great if I could
have all of the fields with their descriptions on a piece of paper.

Thanks much in advance,

Teo
 
D

Dave

Access has a built in system to do this called Documenter.

Go to:
Tools
Analyze
Documenter

then select all the tables

then select options and select the information you want
then click OK
a report is produced which you can then print out

hope this helps
Dave
 
T

Teofilo Homsany

Thanks much Dave, did it and worked :)

Teo
Dave said:
Access has a built in system to do this called Documenter.

Go to:
Tools
Analyze
Documenter

then select all the tables

then select options and select the information you want
then click OK
a report is produced which you can then print out

hope this helps
Dave


that
Click to expand...
 

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

How do I clear a form? 0
table design view information 3
table design view information 1
VBA - exporting serial letters to single documents 0
Data Type Issue in Linked Excel Table 7
Copy a linked table, including descriptions 2
Export to Excel 3
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2

Top