How to read Data from Excel File in SSRS Report - SQL Server Reporting Services(SSRS)

Scenario:

Let's say we get excel file on daily basis and we would like to use Excel file data in our SSRS Report, How can we use that Excel file in SSRS Report?

Solution: 

Here are the steps to read data from Excel file and use in SSRS Report.

Step 1: 
Create the DSN entry for Excel sheet.
Go to Control Panel and then Administrative Tools

Step 2:
Create the DSN entry as shown below.
Provide the Data Source Name and Browse to  Excel file.


Step 3:
Create the report in SQL Server Data Tools, Create Data Source as shown below


Step 4:
Create the DataSet by using below query.

Select * From [Sheet1$]

From here you can create Report as you like as fields will be available in data-set.





6 comments:

  1. hi,

    Thanks for the article. Suppose i got two sheets in the excel file. Am I able to query the second excel sheet similar to what you have explained?

    ReplyDelete
  2. I guess I am the only one who came here to share my very own experience. Guess what!? I am using my laptop for almost the past 6 years, but I had no idea of solving some basic issues. I do not know how to Download Cracked Pro Softwares But thankfully, I recently visited a website named PCexe.org
    All Pro Cracked Softwares Download
    Virtual DJ Pro Crack
    VueScan Pro Crack
    Panda Antivirus Pro Crack
    Windows 12 Pro Crack
    Microsoft ISO Downloader Crack

    ReplyDelete
  3. I like your all post. You have done really good work. Thank you for the information you provide, it helped me a lot. I hope to have many more entries or so from you.
    Very interesting blog.
    Gcpro Gsm Tool Crack
    Microsoft Excel Crack
    Adobe Acrobat Pro DC Crack
    Virtual DJ Pro Infinity Crack
    SuperCopier Crack
    Rekordbox DJ Crack
    Adobe Premiere Pro Crack

    ReplyDelete
  4. I found what I was looking for. Thank you for this post. Please keep it up.
    https://crackmypc.com/microsoft-office-2010-crack

    ReplyDelete