Link Visio shape data to a database

The UK's most regular instructor-led training courses.
Training information: ms visio london · Visio training providers

Resolved · Medium Priority · Version 2003

Link Visio shape data to a database

Jane has attended:
Visio Advanced course

by - delegate Jane [3 posts] (2008 Jul 22 Tue, 09:50) Reply

I would like to know the process for linking custom properties from shapes in a drawing to a database (e.g an Access database). If I change the data in a shape can it then link back to the database & vice versa?

Thanks.

Version	Date	Location	Places available	Book	Next place rate:
Visio Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Dec 12 Fri	Tooting	0	FULL
2003	2009 Jan 6 Tue	Bayswater	8	book now	£225	£245
2003	2009 Mar 3 Tue	Bayswater	8	book now	£225	£245
2003	2009 May 5 Tue	Bloomsbury	8	book now	£225	£245
2003	2009 Jul 7 Tue	Bayswater	8	book now	£225	£245
2003	2009 Sep 11 Fri	Bayswater	8	book now	£225	£245
Full Schedule: See all 7 Visio Advanced course dates. Bookings currently available until 5th November 2009.

RE: Link Visio shape data to a database

by - trainer Richard platinum contributer [818 posts] (2008 Jul 23 Wed, 17:29) Reply

Hello Jane,

Hope you enjoyed your Microsoft Visio course with BEST Training.
Thank you for your question regarding Linking Visio to a Database

Inherently, this topic is technical as you are dealing with theconnection of a databse to another program.

Here are some links to give some background info on linking a visio sheet to a database.

http://office.microsoft.com/en-us/visio/HP850505771033.aspx

http://kbalertz.com/319984/Shape-Visio-Drawing-Server-Database.aspx

http://support.microsoft.com/kb/254591

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer

RE: Link Visio shape data to a database

by - delegate Jane [3 posts] (2008 Jul 28 Mon, 12:53) Reply

Thanks Richard, this is a great help.

· Overview of Microsoft Visio
· How Your Business Benefits From Using Visio

Please browse our web site to find out more about
ms visio london and other Microsoft training courses.

Visio tip:

Creating an organisation chart in Visio using Excel data

A quick and easy way to create an organisation chart by importing names and titles stored in list format in an Excel spreadsheet into Visio.

1. Select File, New, Organization Chart.

2. Start the Organization Chart Wizard.

3. At the first step of the wizard, select the 'Information that I enter using the wizard' option, and click Next.

4. At the second step of the wizard, select Excel, then type the name of the file.

5. Select Browse to choose the location you wish to save the file to, click Save, and then click Next.

6. Click OK - a Microsoft Office Excel workbook will open with column headings already entered for you.

7. Replace the sample text with the text you wish to appear in your organisation chart. By holding your cursor over each column heading, you should be able to view data entry tips.

8. Save the Excel file, then close Excel.

9. Proceed through the remaining steps in the wizard to create your organization chart from the data you entered into the Excel file.

Visio's organisation chart wizard will also recognise the following file formats (besides .xls):

- Microsoft Exchange Server Directory (Microsoft Exchange e-mail Address Book).

- Tab- or Comma-delimited text (.txt).

- Org Plus (.txt).

- Microsoft Office Access (.mdb) or any other file format for a database created in an Open Database Connectivity (ODBC)-compliant database application.