E N D
1. Microsoft Visio 2002: Data Import andExport BasicsBarb WayTechnical Lead / VisioEnterprise Support OrganizationMicrosoft Corporation
2. 2
3. 3 Getting Your Business Data into Visio Employee data – organization chart
Business processes – flow chart
Project schedule – Gantt chart
4. 4 Multiple Import Data Sources Microsoft Excel spreadsheets (.xls)
Comma-separated value (.csv) text files
Microsoft Access, Microsoft SQL Server™, and other ODBC-compliant database formats
Microsoft Exchange Server
Sample files:
C:\Program Files\Microsoft Office\Visio10\Samples
5. 5 Data Import/Export Wizards
Organization chart
Flow chart
Time line/project
6. 6 The Organization Chart Wizard
Sample file:
In the Samples folder under\Organization Chart\Sample Org Chart Data.xls
7. 7 The Organization Chart Wizard (2)
8. 8 Choose to Import Data
9. 9 Select Data Format
10. 10 Select the Data File
11. 11 Select the Data Fields to Import
12. 12 Choose Which Fields to Display
13. 13 Create Custom Properties
14. 14 Complete the Wizard
15. 15 The Finished Organization Chart
16. 16 Linked Pages
17. 17 Other Import Types
Flow chart
Project Schedule/Gantt chart
18. 18 Troubleshooting Tips
Import problems –
Verify that the data source is available
Check the data format
Test using the samples included
Layout problems –
Check under File, Page Setup, Layout and Routing
Review the layout options in Help
19. 19 References
Microsoft Visio on MSDN: http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28000456
Microsoft Visio Version 2002 Inside Out
http://www.microsoft.com/mspress/books/5024.asp
Q301576 “Vso2002: Creating Flexible Organization Charts in Visio 2002”
http://support.microsoft.com/default.aspx?scid=kb;US;q301576
20. 20