Export table structure information

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top