adodb query excel spreadsheet, query return sheet row?

[RAYLWARD102]

Experimenting with queries to my worksheet. So far, I can successfully get meaningful results back, but wonder how I can get those results to include the row they were found in??

My query Looks something like "SELECT [test1], [test2] FROM [Sheet1$]"
Want query to get row some how in results "SELECT ROW() as MyRow, [test1], [test2] FROM [Sheet1$]"

Obviously ROW() in my query doesn't work. I dont really want to add a row() formula to a cell in a column either; just thought there should be a way to return the row as a value in my adodb recordset. Any idea's?

 

[RAYLWARD102]

The reason why I'd like to have the row number return in the recordset as a value, is because I need to format the specific row, in Sheet1, in excel, afterwards; by format I mean change the color and other fancy stuff that you'd never accomplish via adodb.

oh!! and the above queries will be more something like "SELECT [test1], [test2] FROM [Sheet1$] WHERE [test1] = "MrExcel"
The query will be applied against a sheed named Sheet1 with named ranges test1, test2. The sheet has about 5000 rows of data. My Query will likley return 2-3 rows and need to know the rows as a value in my query, as mentioned earlier.