Exporting the Design View Structure into Excel

[FredL]

Is there anyway I can export the Design View/Data Structure (that shows the
Field Name, Data Type and Description) onto an excel sheet? I tried copying
and pasting, but that didn't work. There is the documenter, but that report
has a lot of information that I don't need.

Thanks,
Fred

 

[a a r o n . k e m p f]

Select Sc.Name as ColName, So.Name as TblName
From Sysobjects So Inner Join Syscolumns Sc on So.ID = Sc.ID


now export away, it's called a query

 

[FredL]

Not sure I understand this. Let's take this table as an example:
ColumnA ColumnB ColumnC
ABC 1.06 Brushcetta
DEF 2.75 Latte

Design View:
Field Name Data Type Description
ColumnA Text Customer
ColumnB Number Cost
ColumnC Text Item Purchase

What I would want to do is take the design view and put it in excel so that
it looks the same way in excel. I don't need the actual data. There could
be over a 100 Field Names. How would I use your sql below?

Thanks,
Fred