>>
>>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?
>
>as it is a vfp table, add a bracket to WHERE into which recno() has to be BETWEEN, and increment bracket borders in a loop

Hi Thomas,

thanks for the response.

Was there not something to not use RECNO() / RECCOUNT() in SELECT SQL? Do you think it's thrustworthy?

It's a single cursor, it should not be a filterd SELECT SQL (What would be worst).

What if next release breaks behaviour. :)

Lutz