Are you sure you're using XL5 (MS Office 95)? The next version (Office 97) got XL (XL8) up over 60000 rows.
Your -4143 is "default". What version is on your system?
Alan
>>I used the COPY TO TYPE XL5 to copy 4 small char fields to a spreadsheet. The table has around 35,000 records but only 16,870 records copy over.
>>Any thoughts appreciated.
>>
>>Much Thanks
>>Jeff
>
>I use AUTOMATION to open it and save it with "SAVE AS XLS".
>Example:
>
>USE MyTable
>lcDBF = "C:\MyDBF.dbf"
>lcXLS = "C:\MyXLS.xls"
>COPY TO (lcDBF) TYPE FOX2X AS 850
>loExcel = CREATEOBJECT("Excel.Application")
>WITH loExcel.Application
> .Workbooks.Open(lcDBF)
> .ActiveWorkbook.SaveAs(lcXLS, -4143, "", "", .F., .F.)
> .Workbooks.Close
>ENDWITH
>RELEASE loExcel
>