Export Access table structure in a Word table

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Additional hint:
With the documenter Report open.
Press Ctrl + G
type:
?Reports(0).recordsource

HTH

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

Federico
 
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
 
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
 
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
 
thank you i will give a look! maybe i can save the db in an older access
format! ;-)

federico
 
Back
Top