>I was trying to copy the records from a vfp table to an excel file from my application. When I use copy to or export command, it copies only 16384 to excel file. I need to copy more than 20000 records, Is there a way to do that?Seems you do not have VFP8 which upped the limit (on its driver) to 65535. Previously the driver allowed only up to 16384 records.
One way around it is to save it to an old Fox DOS format and then import into Excel using automation:
USE MyTable
lcDBF = "c:\temp\MyDBF.dbf"
lcXLS = "c:\temp\MyXLS.xls"
COPY TO (lcDBF) TYPE FOX2X
loExcel = CREATEOBJECT("Excel.Application")
WITH loExcel.Application
.Workbooks.Open(lcDBF)
.ActiveWorkbook.SaveAs(lcXLS, -4143, "", "", .F., .F.)
.Workbooks.Close
ENDWITH
RELEASE loExcel
HTH