About the Database Export Wizard

If your shapes have shape data, you can run the Database Export Wizard to create a database table containing that data.

Note: The difference between the Database Export Wizard and the Export to Database dialog box (on the Tools menu) is that the wizard takes you through the process step by step. If you're comfortable working without the wizard's guidance, you may find the Export to Database dialog box more streamlined.

How shapes, records, tables, and fields relate in a database

Each shape in a drawing is represented by a record (or row) in a database table, and each ShapeSheet cell is represented by a field (or column). Data in a ShapeSheet cell appears as a value in the corresponding database table field.

Shape custom properties and cells represented in a database table

The Database Export Wizard and ODBC

The Database Export Wizard exports Microsoft Office Visio data to database tables created in database programs that are Open Database Connectivity (ODBC)-compliant, such as Microsoft Office Access and Microsoft SQL Server.

ODBC is an industry standard that Microsoft programs can use to access, view, and modify data from databases.

To determine whether your database program is ODBC-compliant, check the program's documentation.

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.