>>>>>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!
>>>
>>
>>I don't have VFP 5 installed, but I'm pretty sure it supports CSV. (Is it possible you typed CVS instead? I do that a lot.)
>>
>>Tamar
>
>

>copy next 30000 to test type csv
>copy next 30000 to test type xls
>

>
>I get an error on the first line, but not on the second.
>In any case, what would the advantage be of CSV over DELIM? Even with CSV, you would presumably need to go through the tedious process I described above.

Son-of-a-gun. I just checked my older versions of HackFox and I don't see CSV even in HackFox 6. The difference between CSV and DELIM is that CSV includes filenames and Excel can read a CSV directly.

Tamar