Excel Data source for report without using ODBC


  • 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?


    Craig Bryden - Please mark correct and/or helpful answers

    Monday, April 30, 2012 4:26 AM


  • 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:


    Bin Long

    TechNet Community Support

    • Marked as answer by Craig Bryden Tuesday, May 01, 2012 5:34 AM
    Tuesday, May 01, 2012 5:05 AM

All replies