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

Excel, ADO and row number
 

Hi Sebho

See this page
http://www.rondebruin.nl/accessexcel.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Sebho" wrote in message ...
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