Connect Excel to SQL server 2010 (Denali)

![alt text][1]Hi All, I know we can connect MS Excel 2003 to SQL 2005/2008 OLAP cubes using ODBC. can we connect Excel 2003 to SQL Server 2010 or do we need Excel 2007/2010? Or is it possible to connect Excel 2003 using newer ODBC drivers? If so, can someone tell me where do I find the compatible drivers? Attaching error screenshot Thanks in advance, Mandar [1]: /upfiles/excel_sql2010.JPG

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mandar Alawani commented · Aug 10, 2011 at 11:48 PM

can someone pls help me on this??? Any help is highly appreciated...

0 ·

Fatherjack ♦♦ commented · Aug 11, 2011 at 12:11 AM

have you tried it? I dont know of any changes in Excel that would prevent an ODBC connection working...

0 ·

Mandar Alawani commented · Aug 11, 2011 at 12:24 AM

I have tried sql 2005 and sql 2008 , it works fine from excel 2003...but for SQL 2010 denali , it gives me error: SQL Server Error: 53 Connection failed. SQL State: '08001' SQL server Error :17 Note: How do I attach a screenshot here?

0 ·

Fatherjack ♦♦ commented · Aug 11, 2011 at 12:56 AM

you will need to edit the question to add a picture. When you are editing there will be a small toolbar just above the question text - use the relevant button to add a picture.

0 ·

Fatherjack ♦♦ commented · Aug 11, 2011 at 12:59 AM

Take a look at Connect to see if others have already spotted the issue and if there is a workaround. If not then create an item for it.

0 ·

question