How can I read only the first row from an Excel file using OleDbDataAdapter?

Question

Can someone help me? How can I read only the first row from an Excel file using OleDbDataAdapter?

I know how I can read all the data from any distribution sheet:

var dataAdapter = new OleDbDataAdapter("SELECT * FROM [" + sheetName + "$]", oledbConnection);

But I do not know how to do this for one line.

Answer 1

select top 1 * from ... 

Answer 2

You can refer to the range:

var dataAdapter = new OleDbDataAdapter("SELECT * FROM [" + sheetName + "$A1:C2]", oledbConnection);