Excel ER diagram SQL Server import data tables using .NET code (Excel Add-in)

I wou开发者_运维技巧ld like to import data from SQL tables into an Excel sheet and upon doing so, I would like to show the ER diagram of these sql tables. Whats is the best way to achieve this?

Copy the picture of the diagram to the clipboard and paste it in a Word doc.

As an addition to Beth's answer: you will need a tool for creating an ER diagram. If you don't have one at hand, read this SO post:

SQL Server to er model

EDIT: if you don't want to build your own ER diagram layouter by yourself (something I would not recommend), you should try to find a third-party component for that. Don't expect to get that for free. Here is one capable of creating ER diagrams:

ActiveX edition: http://www.mindfusion.eu/flowchartx.html

.NET edition: http://www.mindfusion.eu/flowchart-net.html

(disclaimer: I do not have anything in common with the vendor, and I did not try it by myself).