Pseudo code:

m.llFirst = .T.
Do While .T.
   If m.llFirst
      Select Top 100 * From yourtable Order By youruniquefield Into Cursor yourcursor
   Else
      Select Top 100 * From yourtable Order By youruniquefield Where youruniquefield > m.lcUniquedata Into Cursor yourcursor
   Endif
   FeedIntoExcel()
   If Reccount() = 100
      Goto 100
      m.lcUniquedata = youruniquefield
   Else
      Exit
   Endif
Enddo

>Hi,
>
>todays problem #1
>
>I have a generic table, I know nothing about it then taht wahta I could read via VFP functions.
>
>In special:
>-no order
>-no index
>
>I need to move this into an excel spread sheet.
>I do this with an array to write into Excel
>Now the table is a bit large, so I get OLE Errors.
>
>Should not be a problem, I can write in chunks.
>
>But now I need to chunk the table
>Like (example)
>First 100 recs
>Next 100 recs
>....
>Last recs
>
>Is there a way to do this with VFP SQL (note: no chance for SELECT TOP, no ORDER given ...)
>
>Any other idea how to do this?
>
>Lutz