View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] gimme_this_gimme_that@yahoo.com[_2_] is offline
external usenet poster
 
Posts: 236
Default Dynamic Range Selection 1,000 rows at a time

Hi Kirk,

You can handle this with mutliple queries to your database.

The syntax is database dependent.

In oracle you'd have

select * from mytable where rownum 1000 and rownum < 1000;

If you're using DB2 let me know - I'll get the exact syntax.