Hey Kevin,
I think that is a limit in Excel 95(?). I think in Excel 97 it is raised to 65,536 rows. You use several pages if you needed to. I've found that the fastest way to do this is to use VFP.DataToClip() and paste it onto the Excel sheet.
Which building are you in? I'm in URP1.
HTH
>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!!!
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement