Linking Visio chart with excel database?

[Devin]

I have created an organizational chart in visio 2003 and am now attempting to
link it back to the excel document. I tried using both the database wizard
and the link to database under visio extras, but no success. I cannot even
get all the way through the wizard. It will not allow me to define a table to
link the document to, and says that the connection has failed. Do i need the
ODBC tool? Is excel compliant? Please help!

 

[Chris Roth [MVP]]

Hi Devin,

If you start with Visio's Org Chart Wizard template, there's a wizard that
helps you to link various database types to an actual Org Chart feature -
maybe this will get you further down the line?

With the Database wizard, you could link data to each employee, but it
wouldn't connect underlings to superiors or do any layout for you...but you
could always add a little code to do this, if you're up for it : )

--
Hope this helps,

Chris Roth
Visio MVP

Free Visio shapes:
http://www.visguy.com/category/shapes
Visio programming info:
http://www.visguy.com/category/programming/
Other Visio resources:
http://www.visguy.com/visio-links/