| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Table Relationships | Excel Discussion (Misc queries) | |||
| View values; ignore header database | Excel Programming | |||
| external database to view in EXCEL format | Excel Discussion (Misc queries) | |||
| How do i change my database to list view | Excel Discussion (Misc queries) | |||
| Table relationships in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
