Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Jacksonville, North Carolina, USA
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking Visio Org Chart to Access Database (2003)

    I have developed a Visio organizational chart w/ employee data from an Access database. Currently, it is perfect w/ title blocks, freestanding text, etc. In the next week someone will surely resign or be hired. How do I refresh my Visio org chart w/ based on updated information from my Access database without having to re-create my cosmetically perfect org chart each time?

  2. #2
    Star Lounger
    Join Date
    Jul 2006
    Location
    Colorado, USA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking Visio Org Chart to Access Database (20

    How did you develop the org chart in the first place? Did you have the database draw it? If you created it by hand based on database info, you have a problem. It will have to be tweaked by hand. Was the Import Flowchart Data Wizard or Org Chart Wizard used?

  3. #3
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Jacksonville, North Carolina, USA
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking Visio Org Chart to Access Database (20

    The Org Chart Wizard was used.

  4. #4
    Star Lounger
    Join Date
    Jul 2006
    Location
    Colorado, USA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking Visio Org Chart to Access Database (20

    That's a tough one. I can only guess that you will have to tweak the existing one by hand or else modify the file it runs off (text, Excel, or whatever) and format the regenerated chart. I once wrote a bunch of VBA code to take data like that from an Excel spreadsheet and draw such a chart according to criteria I gave it, but that is a LOT of work. Perhaps have the old one open and run the wizard with the new data and compare side by side. Drag and drop what is needed. I'm out of ideas. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •