Hello all!
I have an Excel problem that I was wondering if anyone else has run up against and if so how they may have got around it.
It seems that Excel can only handle up to 16,383 records in a worksheet. In my program, a excel file is created from VFP and then excel is opened with that file. IOW:
loexcel = createobject('Excel.Application')
loexcel.workbooks.open((localpath)+"query.xls")
loexcel.visible = .t.
The problem is that it will only show the first 16,383 records. Does anyone know a workaround for this? Or am I missing something simple here? I was thinking about breaking up the data and opening multiple worksheets in a workbook but I'm not sure how to do this or if it would even work.
Any help would be appreciated!
Thanks!!!