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

Question

Hi all.

Can anybody help me? How can I read only first row from an Excel file with OleDbDataAdapter?

I know how I can read all data from any spread sheet:

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

But I don't know how can I do this for one row.

Answer 1

select top 1 * from ... 

Answer 2

You can refer to a range:

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