Exporting Shape Data to a Database

When you export shape data, you can choose the shape data and ShapeSheet cells to export either from selected shapes or all the shapes on a drawing page. The Export To Database command on the Tools menu works with the ODBC Data Source Administrator, which is part of the operating system, to connect you to a data source or create a new one. After you have established an ODBC connection, you can export shape data to an existing database table or to a new table in an existing database, as Figure 24-3 shows.

Figure 24-3. When you export shape data, Visio 2007 creates a new table in an existing database or a NewTable worksheet in an existing Excel file, as shown here.

By default, Visio 2007 ...

Get Microsoft® Office Visio® 2007 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.