Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COPY TO x TYPE XL5
Message
From
23/01/2001 22:19:59
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00467264
Message ID:
00467728
Views:
10
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 &&  RECCOUNT("MyTable") > 16384 records !!!
>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
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform