Export to Database dialog box

ODBC data source

Name

Choose a data source if you have already created one.

Create

To make a new data source, click Create. Follow the Create New Data Source wizard. After you click Finish, the ODBC Setup dialog appears. From there you can either select an existing database or create a new one. You will make the table in the database later.

tiplist

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

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

Browse

If you have a data source stored somewhere other than the default location, click Browse to locate the file.

Qualifier

Choose the database with the table you want to link to. This option is only available for database programs, such as Microsoft SQL Server, where connecting to a data source gives you access to multiple databases.

Owner

Choose All Users or the name of a database creator. Choosing a specific creator limits the number of tables displayed in the Table list. This option is only available for database programs such as Microsoft SQL Server that let you specify an object creator.

Table

Choose the table you want to export data to. To create a new table and export data to it, type a name for the new table.

Key field details

Field

Creates a key field in the database table called ShapeKey by default. To rename it, type a name.

Type

Specifies the values for the key field.

• Choose ShapeID to use a number Microsoft Office Visio assigned to a shape according to the order in which the shape was created on the page.

  No two shapes in the same drawing page will have the same ShapeID.

• Choose GUID to use a unique null-terminated, 128-bit number assigned to each shape when you export its data. No two shapes in the same document will have the same GUID.

Make key field the primary key for table

By making the key field a primary key field, your database program can access the field faster. Not all Open Database Connectivity (ODBC) data sources can mark fields as primary key fields.

Cells to export

Cells to export

Lists the cells that will be exported.

Cell The name of the ShapeSheet cell that will be exported.

Evaluate as Shows how data is evaluated when it is copied from the cell to the database field.

Field The name of the database field the shape data will be copied into.

Type The data type for the database field. The data types you can use depend on which database program you are linking to.

Tip: See the documentation of the program you're exporting your data to for more about available data types.

Length Type the size in bytes of a variable length field.

Decimal Type the number of decimal places supported by the field. This applies only to numeric fields that are not integers.

Add

Click to add a new cell to the list of exported cells.

Modify

Click to modify the link between the selected cell and a database field.

Delete

Click to remove the selected ShapeSheet cell from the list of exported cells.