Hi,

I am managing a large database--several hundred tables. The current system
I inherited employs an Excel spreadsheet to manage the details (description,
business rules, etc) of the tables and fields. We would like to convert the
information in this spreadsheet to a more convenient Access database;
however, the information in the spreadsheet has unfortunately not been
maintained with the development of the database.

To seed the new Access dictionary database, I would like to get a dump of
all tables and associated field names from SQL Server. Conveniently, the dump
would be in a format similar to:
TableName1 TableName2 ...
FieldName1.1 FieldName2.1
FieldName1.2 FieldName2.2
FieldName1.3 ...
....

I don't really care what the fields are exported as, CSV, xls, whatever. I
would just prefer to copy these to the new Access data dictionary rather than
type them in manually.

Any ideas?

--Mike

Hi Mike,

"M. Grass" <M. Grass (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:5F6DBD09-83AE-4A94-AA73-A99C9EAB2812 (AT) microsoft (DOT) com...
not immediatley, but why do you want such a strange format for the data?
Access is a relational database also, so you could just dump the schema
information nearly 1:1 from the sql server.
I think what you realy need are the right formulars in Access.

Helge

How about something like: -

select table_name
, column_name
, ordinal_position
, data_type
from information_schma.columns
order by table_name
, ordinal_position

"M. Grass" <M. Grass (AT) discussions (DOT) microsoft.com> wrote