ODC Creation in Excel 2007

Written by: Ross Beurmann

ODC creation is a valuable tool in Excel. It is a function that is wizard based and has some extensible features such as inputting SQL Query’s to get specific data sets within the Database. This document will explain how to properly create and store ODC files to build Excel Pivot Tables and Charts against Data …