I believe that the limit is 8192 rows. There are two solutions: As John suggested, you can export to ASCII or some other format and then import into Excel from that format, or the more sophisticated solution would be to use Automation to throw the data in.
>I am trying to export a VFP table to and Excel worksheet and am running into a problem in that the resulting XLS file seems to have a limit to the number of rows that can be imported. If I use the following command: COPY TO test XLS the resulting worksheet does not contain all of the table's records. Does anyone know of a solution to this problem?
>
>Thanks in advance for your help.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05