Converting an Access table to a Visio organization chart

P

Peter Tadmor

1. How do you convert an access data table to a visio organization chart?

2. Can you change the headings "Name" and "Reports to" to other headings and
how?
 
A

Arvin Meyer [MVP]

Peter Tadmor said:
1. How do you convert an access data table to a visio organization chart?

2. Can you change the headings "Name" and "Reports to" to other headings and
how?
Click to expand...

If you ask in the Visio newsgroups, you may get an answer to this question.
Last summer at Tech-Ed I saw one of the Visio MVPs give an informal
demonstration on just your question.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
B

Bob Miller

1)
On the File menu, point to New, point to Organization Chart, and then
click Organization Chart Wizard.
On the first wizard page, click Information that's already stored in a
file or database, and then click Next.
On the next Wizard page, select ODBC-compliant data
On the next Wizard page, select MS Access Database
On the next Wizard page, find the database files
On the next Wizard page, select the appropraite table
On the next Wizard page, select the field for the positions name and
the Reports to.
On the next Wizard pages, select other info you want
On the next Wizard page, select whether you want to copy or link the
data.
On the last Wizard page, slect whether you want the wizard to arrange
the charts or you. If you do it it will ask specifics about individual
pages. I prefer to do it myself.

2)
Yes
 
Top