If your shapes have custom properties you can run the Database Export Wizard to create a database table containing those properties.
The difference between the Database Export Wizard and the Export to Database dialog box (found under the Tools menu) is that through the wizard you can choose to export all shapes on a layer. If you don't need to export by layers, you might find the Export to Database dialog box more streamlined.
Using the Database Export Wizard
- On the Tools menu, point to Add-Ons, then point to Visio Extras, and then click Database Export Wizard.
- Follow the instructions on the wizard pages.
Tips
Cell names of the custom properties appear in the list 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 Table Export.
Using the Export to Database command
- On the Tools menu, click Export to Database.
- Select the database table you want to use.
- If you have a data source stored somewhere other than the default location, click Browse to locate the file.
- To make 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 make the table in the database later.
Tips
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.
- If your database supports owners, in the Owner list, click an owner name to filter the list of the table owners. The database table is created using the name you logged on to the database with.
- If your database gives you access to multiple databases, in the Qualifier list, click the database you want to use.
Tip
If you are using Microsoft Office Access or Excel, the name and location of the database your data will be exported to is listed here.
- In the Table list, click the database table you want to use. To create a new table, type a name for it.
- If you want, change how data will be exported from ShapeSheet cells.
Add a ShapeSheet cell to the export list
- Click Add.
- Select the ShapeSheet cell you want to export.
- In the Evaluate as box, select the data type for the value stored in the database field.
- Select the database field into which shape data will be copied.
- Specify the database data type, field length, and decimal precision of the database field.
Modify how data in a ShapeSheet cell is exported
- Select a cell name and click Modify.
- Change how data will be exported.
Delete a ShapeSheet cell from the export list
Select a cell name and click Delete.
United States
Email this link
Printer-Friendly Version
Share
Hide All
