Excel, ADO and row number
Hello,
i have to request an Excel Sheet,
so i have an oledbCommand : "SELECT * FROM [sheet1$]"
this is ok, it works
but i want just some lines (no all table) and i know her excel line number,
i would like to do anything so : "SELECT * FROM [sheet1$] WHERE row_num=3"
row_num does not exist, bus is there an "system field" (rownum, rowid,...)
who can do this ?
best regards,
--
Sebho
|