>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
Luis María Guayán
Tucumán, Argentina
________________________________
SysOp de
www.PortalFox.comNada corre como un zorro
________________________________