Import data from external sources to Visio 2007

Author: mety Nagm Labels::



Step 1: Import your data

In this first step, you use the Data Selector Wizard to import your data into the External Data window.
The data that appears in the External Data window is a snapshot of your source data at the time of import. You can update the data in your drawing to match the changes in your source data. However, you cannot refresh your data source by changing the data in your drawing. .
  1. On the Data menu, click Link Data to Shapes.
  2. On the first page of the Data Selector Wizard, choose which of the following types of data sources you want to use:
    • Microsoft Office Excel workbook
    • Microsoft Office Access database
    • Microsoft Windows SharePoint Services list
    • Microsoft SQL Server database
    • Other OLEDB or ODBC data source
    • Previously created connection
  3. Complete the remainder of the wizard. Note If you choose an option other than an Excel workbook, Access database, or SharePoint list on the first page of the wizard, you may be temporarily diverted to the Data Connection Wizard in the course of completing the Data Selector Wizard.
    Specific help is available for most wizard pages. To access Help, press F1 or click the Help button.
After you click Finish on the last page of the Data Connection Wizard, the External Data window appears with your imported data shown in a grid.

Step 2: Link rows of data to shapes in your drawing

There are three ways to link rows of data to shapes in your drawing: You can link rows to existing shapes one at a time, you can link the rows to shapes automatically, or you can create shapes from the data.

Link rows to existing shapes one at a time

This approach is best for existing drawings with relatively few shapes.
  • Drag a row from the External Data window onto a shape in your drawing. Your data appears in the shape, and a link icon appears to the left of the row in the External Data window.
    Drag row onto shape Notes
    • You can link a single row to multiple shapes, but you cannot link multiple rows to a single shape.

    • To display the External Data window, on the View menu, click External Data Window.

Link rows to existing shapes automatically

This approach is best for existing drawings with a large number of shapes. This works only if the shapes have data already in them that you can match to data in the data source.
  1. On the Data menu, click Automatically Link.
  2. Follow the steps in the Automatic Link Wizard. Your data will appear in your shapes.
Specific help is available for most wizard pages. To access Help, press F1 or click the Help icon.

Create shapes from your data

This approach is best if your drawing doesn't already have shapes, and you don't need to use specific shapes.
  1. Click a shape in the Shapes window.
  2. Drag a row or set of rows from the External Data window onto a blank space in your drawing. One instance of the shape that you click appears for each row that you drag onto the drawing.

2 comments |
  1. Can you publish this drawing with associated shape data still linked to external data source file? Will Visio automatically put this external data source file into the "files" folder? Then can you change the data in the external data source file and when you refresh the browser will it update the published Visio web page? I've been searching for days and can't figure this one out. Then can you link shape data properties to an inserted image with an if/then/else statement? For example if I complete a step in the process then display green check mark else display red x?

  1. Here some useful links in this subjected Using data


    Overview of data connection features in Microsoft Office Visio 2007
    http://office.microsoft.com/en-us/visio/HA101154631033.aspx
    Importing data into shapes
    http://office.microsoft.com/en-us/visio/CH100991461033.aspx


    Manually adding data to shapes
    http://office.microsoft.com/en-us/visio/CH100991471033.aspx


    Displaying data
    http://office.microsoft.com/en-us/visio/CH100991501033.aspx


    Exporting data
    http://office.microsoft.com/en-us/visio/CH101779671033.aspx


    Refreshing data
    http://office.microsoft.com/en-us/visio/CH100991491033.aspx


    Working with the External Data window



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

    I hope you find what you looking for

Labels

Blog Archive

Powered by Blogger.

I made these pages for me and my friends to help solving the problem we face regarding Computer & internet, if anyone wants me to answer a question or find out about some information please send me email and I will try to reply.*P.S. some of the article I wrote and the other I found on the internet I posted them in sprit of learning and shearing, please forgive me if you found something you don’t want to be in my blog, email me and I will delete them. Thank you for your interest in my pages.امل نجم Amal Nagm

banner 1 banner 2