Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does COPY TO...TYPE XLS have a record limit in 6.0?
Message
 
To
06/10/1999 07:44:17
Victor Lapid
Phil. Long Distance Tel. Co.
Manila, Philippines
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00272470
Message ID:
00273099
Views:
21
>John,
>
>
> I'm using VFP5.0a and i have the same problem with yours. What i do is instead of copying it into an excel file , copy it as a text file like , copy to filename type sdf , then all your records will be save as a ttext file. Open this text file from an EXCEL application and manually set all columns(fields) into a text format. Copy to ... type xls has a limitation of 16,000 records in a dbf file.

You can also do a straight OLE PasteSpecial from vfp to Excel for more records, though it might be a little slow for a great many records.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform