Run the Microsoft Office Visio Database Export Wizard (available in the Visio Extras folder from the Add-Ons entry on the Tools menu) or open the Export to Database dialog box (available on the Tools menu) to create a database table containing shape properties.
The difference between the Database Export Wizard and the Export to Database dialog box is that the wizard takes you through the process step by step. If you're comfortable working without the wizard's guidance, you might 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.
Exporting data and ODBC
The Database Export Wizard and Export to Database dialog box export Visio data to database tables created in programs that are ODBC-compliant, such as Microsoft Office Access and Microsoft SQL Server.
ODBC (Open Database Connectivity) 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.
United States
Email this link
Printer-Friendly Version
Share
Hide All
