Export shape data to a database

If your shapes contain data, you can run the Database Export Wizard to create a database table that contains that data.

The difference between the Database Export Wizard and the dialog box that is reached by using the Export to Database command is that through the wizard you can choose to export all shapes on a layer. If you do not need to export by layers, you might find that using the Export to Database command is more streamlined.

Using the Database Export Wizard

  1. On the Tools menu, point to Add-Ons, point to Visio Extras, and then click Database Export Wizard.
  2. Follow the instructions on the wizard pages.

ShowTips

Cell names of the shape data that appear in the list are preceded by Prop, such as Prop.Cost.

When you run the Database Export Wizard to export shape data, the wizard stores export-related information with the drawing page. If you make changes to the shapes and want to export the data again, right-click the drawing page, and then choose Database Export Table.

Using the Export to Database command

  1. On the Tools menu, point to Add-Ons, then point to Visio Extras, and then click Export to Database.
  2. Select the database table that you want to use.
    • If you have a data source stored somewhere other than the default location, click Browse to locate the file.
    • To create a new data source, click Create. Follow the Create New Data Source wizard. After you click Finish, the ODBC Setup dialog box appears. From there you can either select an existing database or create a new one. You will create the table in the database later.

 Notes 

If you are using Microsoft Office Excel as a data source, you can select an existing workbook, but you can not create one from the wizard.

If you choose an Excel workbook, be sure to clear the Read only check box in the Select Workbook dialog box.

  1. If your database supports owners, in the Owner list, click an owner name to filter the list of table owners. The database table is created using the name you used to log on to the database.
  2. If your database gives you access to multiple databases, in the Qualifier list, click the database that you want to use.

 Tip   If you are using Microsoft Office Access or Excel, the name and location of the database that your data will be exported to is listed here.

  1. In the Table list, click the database table that you want to use. To create a new table, type a name for it.
  2. If you want to change how data will be exported from ShapeSheet cells, do one of the following:

ShowAdd a ShapeSheet cell to the export list

  1. Click Add.
  2. Select the ShapeSheet cell that you want to export.
  3. In the Evaluate as box, select the data type for the value that is stored in the database field.
  4. Select the database field into which shape data will be copied.
  5. Specify the database data type, field length, and decimal precision of the database field.

ShowModify how data in a ShapeSheet cell is exported

  1. Select a cell name and click Modify.
  2. Change how data will be exported.

ShowDelete a ShapeSheet cell from the export list

Select a cell name and click Delete.

 
 
Applies to:
Visio 2007