title: Connecting to an SQL Server User Defined Function from Excel
body: <p>I have created an Inline Table-Value User Defined Function in SQL Server</p>
  
  <p>I would like to input the parameters in various cells in an Excel spreadsheet, and have a table that will update with the results from those parameters when I enter them.</p>
  
  <p>Normally, I do this with Microsoft Query, but that doesn't allow me to call a User Defined Function. So how do I go about creating an odc file, or otherwise connecting to that function?</p>
  
  <p>I am using Excel 2010 and SQL Server 2008</p>