Hi Bill,

I'm in One First Union. But I've done some work out at URP recently so I may have seen you around.
Actually, I'm using Excel 97 and it still seems to have that limit. I'm a little hesitant about using DataToClip as I may have up to half a million records that would need to be created in Excel and I think there might be a speed issue there. What I want to do is break up my created data file by 16,383 and then open each created one in a different worksheet. But I'm not sure how to open multiple worksheets through OLE or if the limit is based on a worksheet or based on the whole book.

Any ideas?
Thanks!

>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