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.





13 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. Many thanks for sharing such incredible knowledge. It's really good for your Website.
    The info on your website inspires me greatly. This website I'm bookmarked. Maintain it and thanks again.
    I'm really impressed with your writing skills, as smart as the structure of your weblog.

    Microsoft Excel Crack
    iSkysoft Data Recovery Crack
    Proteus Crack

    ReplyDelete
  3. After reviewing some of the ads on the site,
    We really appreciate the way you write your blog.
    We've added it to our bookmark list and we'll be back soon.
    Future. Also, check out my site and let us know what you think.
    You did a great job and worked hard. I appreciate your work, thank you for sharing.
    CrackBins Full Version Softwares Free Download
    CrackBins Full Version Softwares Free Download
    UniPDF PRO Crack
    MediaMonkey Gold Crack
    Varicad Crack
    FinePrint Crack
    VueScan Pro Crack
    Renee PassNow Crack
    Microsoft Excel Crack

    ReplyDelete
  4. 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
    Mirillis Action Crack
    Bootstrap Studio Crack
    Simplify3D Crack
    EaseUS Todo PCTrans Pro Crack
    FastKeys Crack

    ReplyDelete
  5. 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
  6. 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
  7. I found what I was looking for. Thank you for this post. Please keep it up.
    https://crackmypc.com/microsoft-office-2010-crack

    ReplyDelete
  8. I like your all post. You have done really good work. Thank you for the information you provide, it helped me a lot. crackdoc.org I hope to have many more entries or so from you.
    Very interesting blog.
    Virtual DJ Pro Crack
    DVDFab Crack

    ReplyDelete
  9. Very good article! We will be linking to this particularly great post on our website. Keep up the good writing.Latest Software Crack Free Download With Activation Key | Serial Key | Keygen | Torrent Crack PC Softwares Free Download
    activationcrack.com
    VirtualDJ Pro
    Emsisoft Anti-Malware
    PowerISO
    Wise Disk Cleaner

    ReplyDelete
  10. 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.
    Free Netflix Downloader Premium Crack
    SuperCopier Crack
    R-Studio Network Technician Crack
    PDFescape Crack
    ReclaiMe Pro Crack

    ReplyDelete