[Damage]

Hi

Not sure if this is the right place for this. what i'm doing is getting a dataset from an excel spread using a simple sql query.
What i want to do in the where clause is avoid selecting the first few rows but i haven't had any success

So far it's just

select [F2] ,[F3],[F4]  from [Current$] where ID is Null

what i would like to do is remove the where id is null clause and use some thing like

where [rowindex] > 0

but that doesn't work.

This post has been edited by Damage: 01 June 2011 - 09:09 PM

[June7]

You can use a named range reference or row/column notation.

strQuery = "SELECT * FROM MyRange"

strQuery = "SELECT * FROM [Sheet1$A3:B10]"

See: http://support.microsoft.com/kb/257819