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