Export Access table structure in a Word table

G

Guest

good morning all,

we are developing a complex electronic system related to the energy saving;
a central and remote server control and manage all the systems installed in
the territory. This server has a big database to collect all the structural
and operational systems information; we are designing the database using
Microsoft Access. Since we have to describe the entire system, and so even
the database structure and relations, we need to copy the database tables
structure in a word report document (including the fields names, the kind of
data and the description of every table field). It seems a silly things, but
we are not able to export the structure of the table in a word table (the
copy-and-past function doesn't work in this case) and we cannot copy manually
every field of every table 'cause this is a real time wasting. Does anybody
have an idea how to do? Thank you very much, from Italy

Federico
 
P

Pieter Wijnen

Tools/Analyze/Documenter (access 2003)
The Actual Data to be found in
C:\Documents and Settings\%username%\Application
Data\Microsoft\Access\ACWZUSRT.MDT

HTH

Pieter
 
P

Pieter Wijnen

Additional hint:
With the documenter Report open.
Press Ctrl + G
type:
?Reports(0).recordsource

HTH

Pieter
 
G

Guest

thank you very much. The only thing that seems to be missed is the culomn
"description".

Federico
 
G

Guest

2007

Jeff Conrad said:
Hi Federico,

Which version of Access are you using?

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
 
G

Guest

2007

Jeff Conrad said:
Hi Federico,

Which version of Access are you using?

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
 
J

Jeff Conrad [MSFT]

I have an Access add-in that does this quite nicely:
http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html

Unfortunately, I haven't had time yet to make it compatible with Access
2007.
:-(

You might want to take a look at this page for some options:
http://www.accessmvp.com/JConrad/accessjunkie/doctable.html

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
 
G

Guest

thank you i will give a look! maybe i can save the db in an older access
format! ;-)

federico
 

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

Top