WAG: Sounds like the wrong table/cursor is selected. Is it possible you have a grid somewhere in the mix with 4000 records in its recordsource? If so, before running your export code, set focus to a control other than the grid.
Frank.
Frank Cazabon
On 14/09/2017 05:28 AM, Alan Bourke wrote:
I'm creating Excel output using the XFRX driver. The basis for the report is a cursor which has in my test setup about 40 records. It's created using SQL Select with the nofilter clause. There are no relations in to it or out from it. It is the currently selected table when running the report. The issue is that the XLSX file produced just has the same record repeated about 4,000 times. Any ideas?
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]