none
Excel Data source for report without using ODBC

    Question

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

    Thanks


    Craig Bryden - Please mark correct and/or helpful answers

    Monday, April 30, 2012 4:26 AM

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

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

All replies