Thank you for replying, I used the method you suggested and it worked fine as a work-around.
It would be easier on my client if it could be done directly to an excel-file ..
Best regards from Belgium
>>I try to create an excel-file from a VFP-table.
>>
>>Until now I never had any problem using the very simple syntax:
>>
>>copy to myfile type xls
>>
>>But: when I try to do this with a table with about 20000 records, I only create an .xls with the first +/- 14000 records.
>>
>>Is this a limitation I am not aware off, or can there be another reason?
>>
>>Thank you for any assistance...
>>Ivo Hubert
>
>VFP will only copy the first 16380 records. I don't know of any way to change this from VFP. You could save the table as a foxpro 2.X DBF table using the "type fox2x". Then from Excel I open the DBF table.