Using ODC Files with Visio

I use the Link Data to Shapes wizard in Visio Professional almost everyday, but I have not really bothered to use the Office Data Connections (ODC) files much, probably because there is no easy way of creating them in Visio. However, the Data Connection wizard does allow you to use previously created ODC files. So, I thought I’d document the easiest way I know of creating them … using Excel!

In fact, Excel and Reports can use ODC files too. See http://blogs.office.com/b/microsoft-excel/archive/2008/10/15/using-office-data-connection-files-odc-and-the-dataconnections-web-part-in-sharepoint-to-specify-external-data-connections-in-newly-created-excel-workbooks.aspx

In Excel, select Data \ From Other Sources \ From Data Connection Wizard …

DCW_Welcome

 

You can then select your data source, and import some sample data into Excel.

 

ImportData

You can then save the ODC file…

DCW_SaveAndFinish

 

In Visio, you can then use the saved ODC file with Link Data to Shapes…

 

Visio_DCW

 

You can then select the ODC file, and continue as normal with the External Data in Visio.

Visio_DCW_Existing

 

Useful…. especially when used with SharePoint  as source for Visio Services…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Chris Webb's BI Blog

Microsoft Analysis Services, MDX, DAX, Power Pivot, Power Query and Power BI

davecra.wordpress.com/

Microsoft Office 365 Development, and more...

PowerShell.Amsterdam

Automate, Accelerate, Accurate

johnvisiomvp

Life with Visio and other Microsoft Toys!

Title (Required)

Windows Server Essentials Tips & Tricks

Nilsandrey's Weblog

Just another WordPress.com weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Shapes, Stencils, Drawings Templates, Tutorials, Tips & Developer Info for Microsoft Visio

Hannes's Virtual Earth

Tips & Tricks around Mapping and Cloud Computing

Pluralsight blog

be smart, be clear, be visual ...

%d bloggers like this: