Excel Data source for report without using ODBC

All Replies

• Tuesday, May 01, 2012 3:10 AM

  Moderator

   

   
  

  0

  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

  

  • Reply
  • Quote

   
• Tuesday, May 01, 2012 3:16 AM

   

   
  

  0

  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.

  Thanks

  ---

  Craig Bryden - Please mark correct and/or helpful answers

  • Reply
  • Quote

   
• Tuesday, May 01, 2012 5:05 AM

  Moderator

   

   
  

  1

  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
  •  
  • Reply
  • Quote

   
• Tuesday, May 01, 2012 5:34 AM

   

   
  

  0

  Thanks for your efforts

  I already now how to that ;)

  Thanks

  ---

  Craig Bryden - Please mark correct and/or helpful answers

  • Reply
  • Quote

   
• Tuesday, July 31, 2012 12:57 PM

   

   
  

  0

  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

  • Reply
  • Quote