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