Please check the sample excel sheet I intend to use to get a clear understanding of my question
I need to use datareader to query using a sql statement to retrieve data from the woksheet. I have seen many examples on how to do this but all those consider the first row (Row 1 in spreadsheet) to contain column names. However, in my example it starts in Row 4. So, how do i write a query to read from the table and retrieve the values?