Hi Tore,

thanks for the response.

The problem is, that, as I wrote in the OP, I simply do not know uniquefield or ORDER for that. (It would be ORDER, Unique is not ordered for display :) )

This is a generic exporter that simply puts the cursor in ALIAS() into Excel. It does a bit more, but there is no interface for order, or it would need to remove the order information because it should not be exported.
Also my synthic unique ID should not be visible.

Lutz

>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