Export table structure information

G

Guest

Hi everyone.

Does anyone know how to export table structure information to a file
(.txt/.csv/.xls) to aid documentation of a database?

Items to be exported - Field name, Data Type, Description, Field size,
number/date format etc. - basically what's viewable in the design view.

Each field to be a row, each item to be delimited by a tab, comma etc

Thanks in advance for your help.
 
G

Guest

Try runnung the Access documenter for the objects you want. It will create a
report that you can export to a text file, or better yet with any of the
free PDF print drivers available, save as a pdf file.
go to Tools menu /Anslyze/documenter

Rosco
 

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

table design view information 3
Export Access table structure in a Word table 8
table design view information 1
Export large query from Access 3
How to import and export data? 1
table structure 3
Exporting query to table in external database 4
best way to update table 2

Top