>>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?
>
>Maybe connect to Excel spreadsheet via ODBC? https://www.connectionstrings.com/microsoft-excel-odbc-driver/
>
>Dunno if you can get all your data that way in one shot in a cursor, or if you need to play around with CURSORSETPROP() Fetch*, MaxRecords properties and/or pulling data from "main" cursor into a secondary one 100 rows at a time.
>
>Also dunno if OLEDB/CursorAdapter offers any advantages with this.

Hi Al,

thanks for the response.

This is an idea to think about.

How does ODBC reacts if I cross the line number limits of Excel?

I also do not fill from top to bottom, sometimes I need to start from a specific cell (row and or col # 1)

One can think to fill a temp excel and then copy & paste via automation ...

I keep it as last resort :)

Lutz

I also fill into