View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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