View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cg cg is offline
external usenet poster
 
Posts: 11
Default View the table relationships in a database

I am using Excel and would like to use ADO to go into a database located on a
SQL server and view the relationships between the tables. Basically, if the
table STORES has a primary key field STOREID I would like to see the foreign
keys that are associated with it. Is this possible? If so, can I get the
"result" exported to a text file so I can view each relationship?

Thanks!!!!