Export table structure information

B

Bamboozled

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.
 
R

Rosco

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 table wizard 0
Exporting the Design View Structure into Excel 2
Question on exporting table data. 2
table design view information 1
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Export Access table structure in a Word table 8
Text to Rows 0

Top