Hi I've been fortunate not to be asked to connect to an Excel source for published reports using SSRS before. Until now... I tried using the OLE DB providers but cannot get them working. All articles on using Excel as a data source mention ODBC. Is ODBC my only option? ThanksCraig Bryden - Please mark correct and/or helpful answers

Hi Craig, I recommend you that refer to the following articles about using Excel as a data source in Reporting Services, please see: Using Excel as a Reporting Services data source: http://weblogs.sqlteam.com/joew/archive/2008/08/22/60695.aspx Using Excel As A Reporting Services Data source: http://sqlserverpedia.com/blog/sql-server-bloggers/using-excel-as-a-reporting-services-datasource-2/ Please see the related threads about this topic: http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/7d5cef65-462e-4abe-9cff-8a32c11a0326 http://social.technet.microsoft.com/Forums/vi-VN/sqlreportingservices/thread/3be20b4f-cdd9-4bba-a511-bbb5369203d3 TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here. Thanks, Bin Long TechNet Community Support

Hi I think you may have misunderstood my question. All the articles explain how to use ODBC. I am asking specifically if there is a way to connect to Excel from SSRS without using ODBC. ThanksCraig Bryden - Please mark correct and/or helpful answers

Hello, We can only use ODBC driver if we want to directly use a Excel file as the data source to design a report. By the way, we can import data from Excel to SQL Server. Here is an KB article for your reference, please see: http://support.microsoft.com/kb/321686 Regards, Bin Long TechNet Community Support

Thanks for your efforts I already now how to that ;) ThanksCraig Bryden - Please mark correct and/or helpful answers

Hi Craig, This is maybe a little late but you can connect to Excel using OLE Db, the connection string would look something like this: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"; And then you would be able to use Access style SQL. Joao