>
>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