Home Forums SQL Server 2008 SQL Server 2008 - General SQL Functions in Excel? RE: SQL Functions in Excel?
A. Harmon
SSC Eights!
Points: 995
More actions
May 11, 2010 at 11:28 am
#1165721
I don't think there is an easy way to do this. I believe you'd have to write a user defined function in Excel to make a connection to the database and utilize the scalar function from SQL. It's certainly not an option out of the box