Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting Records to XL
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00575277
Message ID:
00575587
Views:
24
Mike,

Very nice trick!
However it will be DBF4 (.dbf) format, that Excel can recognize and translate upon opening. Also you will be able to use it as a regular table in foxpro.

>select Cursor
>Copy to "filename" XL5
>
>works but is limited to 16K records
>
>try this :
>
>Copy to "filename.xls" FOX2X
>
>will only be limited to the version of excel the user has.
>
>
>>Not quite clear, what do you mean "not converted properly", but try:
>>
>>copy field (field_date) to _excel xls, and
>>copy field (field_date) to _excel5 xl5
>>
>>to see the difference.
>>
>>>Hey guys is there a way to export a cursor to the current version of XL. Eg. XL2000. Currently it exports it as XL2.1 and the dates are not converted properly.
Previous
Reply
Map
View

Click here to load this message in the networking platform