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