Hi Kevin,
I just got that number(65 k+) out of the help file.

First, sorry but I just have to say this, but it sounds like your having to use the wrong tool for the job. Anyway...

With DataToClip you can specify how many records to copy. What I was thinking was copy a page worth to the clipboard, paste it in Excel, move to the next page, etc.

Another option would be to open two (or more) workbooks and drag the worksheet from one workbook to another.

Look me up in FUNMail and give me a call if you need any help.

>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