>>Hi All:
>>
>>Is there any workaround for VFP 5.0 for the following statement (we do
not have the option to upgrade to VFP 9):
>>
>>
>>copy next 20000 to foo xls
>>
>>
>>In this case, only 16,383 records are copied. Changing the 'XLS' to 'XL5' has no effect.
>>
>>On the Excel side, we can handle more records; we're running Excel 2010.
>>
>>Thanks,
>>
>>Yossi
>
>What happens when you copy to CSV?
TYPE CSV is not valid in 5.0. So I used DELIM. The good news is that it will copy more records, BUT when I open the delimited file in Excel 2010, I still need to change field types in the open wizard. If I leave them all as GENERAL, then 'F' translates into 'False' and '03' translates into a numeric 3. In both cases I need to change GENERAL to TEXT. Rather tedious, but that's what you get when working with old versions!
Thanks to you and Rick!