How to convert a model diagram in a SQL Server database into Word--and be able to view property information for a field

1. Model diagram for creating a database in a SQL Server database--database diagrams

2. Control Panel--Administrative Tools--ODBC Data Source link--Create a data source link for SQL Server

3. Open the Visio tool to open the database model--database--reverse engineer[reverse engineering]

Select the tables you want to import into Visio:

4. Import the table structure of DB into Visio, the interface may need to be slightly adjusted

You can view the details of a field in Visio

Save Visio as a file.

5. Open Word, Insert Object

After you import a Visio file into Word, you can double-click the imported picture to see the details of each field in the table.

When someone looks at this Word document, you can view the details of the field if you have Visio installed.

It is also possible to copy a picture directly from database diagrams or in Visio, but you cannot see the details of the field, just a simple picture.