Excel 2010 and SQL Server 2005?

Question

I have Excel 2010, but am connecting to a SSAS server that is SQL 2005. I can only find a Data Mining add-in for SQL 2005 for Office 2007.

Is there any way I can make this add-in work with Excel 2010, or is there an add-in hidden somewhere for Office 2010 and SQL 2005?

Answer 1

There are 2 versions of Microsoft data mining add-in: one that works with SQL Server 2005 and one that works with SQL Server 2008. Both of them were developed for Office 2007. Many people use 2008 version on 32-bit version of Office 2010. I expect 2005 version of the add-in to work as well.

Microsoft doesn't have a version of data mining add-in that works on 64-bit version of Office 2010 yet.

---

Tatyana Yakushev [PredixionSoftware.com]