Prev: Family relationships but not family tree
Next: 2 different images at same position according to a criteria
From: FredL on 1 Jul 2008 20:14
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
From: a a r o n . k e m p f on 2 Jul 2008 01:35
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





On Jul 1, 5:14 pm, FredL <Fr...(a)discussions.microsoft.com> wrote:
> 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

From: FredL on 2 Jul 2008 11:01
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

"a a r o n . k e m p f @ g m a i l . c o" wrote:

> 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
>
>
>
>
>
> On Jul 1, 5:14 pm, FredL <Fr...(a)discussions.microsoft.com> wrote:
> > 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
>
>
 | 
Pages: 1
Prev: Family relationships but not family tree
Next: 2 different images at same position according to a criteria