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

Question

I would 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?

Answer 1

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

Answer 2

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).