Read Excel Sheet Data Using SQL Query

  1. select * from  openrowset  
  2. ('Microsoft.Ace.oledb.12.0','Excel  12.0;Database=D:\Vithal\csharpcornerAuthor.xlsx','Select * from [Deb$]'