| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I click on a telephone number in an Excel 2002 spreadsheet, and have the number dialed? | Excel Discussion (Misc queries) | |||
| Excel. How to round a number to nearest half number? | Excel Discussion (Misc queries) | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
| command to return the row number or cell number in excel? | Excel Programming | |||
Linear Mode
