Data Selector Wizard Connect To Data. In the Edit Property Value dialog box enter the database password. Data Selector Wizard Connect to data Visio Professional 2013 Visio 2013 Visio Premium 2010 Visio 2010 Visio 2007 Use the Connect to data page either to confirm that you want to import all of your data or to launch the Select Columns and Select Rows pages where you can select the columns and rows to import.
The select data dialog is displayed. In the list of properties and values select Jet OLEDBDatabase Password. On the first page of the Data Selector Wizard click Other OLE DB or ODBC data source and click Next.
Do one of the following.
Database connections are optimized based on this attribute. In the Welcome to the Data Connection Wizard page click ODBCDSN. In the Entity Data Model Wizard. 3 Under Connect to Microsoft Excel Workbook select the workbook you want to use then click Next.