Tags: anentity, capable, create, diagram, dictionary, entity, generating, microsoft, msdn, relationship, report, software, visio

Entity Relationship Diagram to Data Dictionary using Visio 2003

On Microsoft » Microsoft Visio

2,310 words with 2 Comments; publish: Fri, 30 May 2008 22:36:00 GMT; (30078.13, « »)

Hi,

I'd like to know if Visio 2003 is capable of generating a report from an

Entity Relationship Diagram. I'd like to create a Data Dictionary from the

diagram in Excel format.

If this is possible, could someone also tell me the exact steps to do this

in Visio and whether it requires Professional or Standard?

Thanks

All Comments

Leave a comment...

  • 2 Comments
    • Visio in Visual Studio .NET 2003 Enterprise Architect is capable of

      generating reports as well as generating databases. I am not sure what you

      are looling for in terms of data dictionary. Excel worksheets may be

      imported into Visio database diagram using generic ODBC driver.

      Chang Oh

      Visual Studio Enterprise Frameworks and Tools

      "kevinh" <kevinh.ms-visio.todaysummary.com.discussions.microsoft.com> wrote in message

      news:39A9095E-CDE3-437C-8E9C-83CC6120147E.ms-visio.todaysummary.com.microsoft.com...

      > Hi,

      > I'd like to know if Visio 2003 is capable of generating a report from an

      > Entity Relationship Diagram. I'd like to create a Data Dictionary from the

      > diagram in Excel format.

      > If this is possible, could someone also tell me the exact steps to do this

      > in Visio and whether it requires Professional or Standard?

      > Thanks

      #1; Fri, 30 May 2008 22:37:00 GMT
    • I am not sure what functionality you are looking for. Visio is not a

      reporting tool for the content in Excel. I believe Crystal Report can be

      used to generate reports off of Excel. If you are interested in modeling

      the structure of your data storage, then Visio can be useful. I haven't

      personally tried, but I believe you can use Generic ODBC driver to reverse

      engineer the table structure of your Excel file.

      Chang Oh

      Visual Studio Enterprise Frameworks and Tools

      "kevinh" <kevinh.ms-visio.todaysummary.com.discussions.microsoft.com> wrote in message

      news:39A9095E-CDE3-437C-8E9C-83CC6120147E.ms-visio.todaysummary.com.microsoft.com...

      > Hi,

      > I'd like to know if Visio 2003 is capable of generating a report from an

      > Entity Relationship Diagram. I'd like to create a Data Dictionary from the

      > diagram in Excel format.

      > If this is possible, could someone also tell me the exact steps to do this

      > in Visio and whether it requires Professional or Standard?

      > Thanks

      #2; Fri, 30 May 2008 22:38:00 GMT