Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Indicate the name of the database table you are exporting to and the type of data for the key field.

Database

Shows the Open Database Connectivity (ODBC) data source you selected on the previous page.

Table name

If the database has tables, they are listed in the lower text box. To export shape data to an existing table, select the table name in the lower text box. It appears in the upper text box. To create a new table and export shape data to it, type a name for the new table in the upper text box.

Key field

The wizard creates a key field in the database table called ShapeKey. The key field uniquely identifies each shape. You can type a new name for the field.

Key type

Specify values for the key field.

  • ShapeID is a number Microsoft Office Visio assigns 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.

  • GUID is a unique, null-terminated, 128-bit string 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 ODBC data sources can mark fields as primary key fields.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×