• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 6: Inside the Visio Platform > Connecting Diagrams and Databases

Chapter 24. Connecting Diagrams and Databases

About Visio and Databases711
Connecting to an ODBC Data Source715
Exporting Shape Properties to a Database717
Linking Shapes and Databases721
Managing Linked Shapes729


Besides making great presentation graphics, Microsoft Office Visio 2003 diagrams are visual repositories of shape information. You can export that information to a database or spread-sheet program or update that information based on the contents of a database or spreadsheet program. For example, suppose you want access to the furniture dimensions stored in an office layout to add to a planning database. You can export shape data, such as dimensions and other properties, to a database, which is a one-way procedure. Or suppose you want to associate shapes that represent parts with the specification data stored in a manufacturing database. You can also create a two-way link between database records and shapes. This latter feature gives you the ability to create dynamic diagrams that respond to data from an external source. In effect, your diagram becomes a visual front end to your database.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint