>>>Hello,
>>>
>>>We use FoxPro Windows v2.6 for certain applications. Now we have a situation where we want to output a report we created with FoxPro to a file instead of to the screen or the printer.
>>>
>>>We would like to output it as a Excel format or any other format (like ASCII or whatever).
>>>
>>>Is this possible? And if so, how can we achive this?
>>>
>>>Thanks in advance!
>>
>>The only way to do this in FPW is to make a duplicate report in DOS and when you want to print the report to ascii then run the dos report. The other option is to load the generic print driver and print to it. I know that there are other print drivers out there for like RTF and AcroBat. You might want to check into these. If you want to upgrade to VFP there is a command called REPORT FORM myReport TO FILE ASCII, which doesn't format it quite right.
>
>If you do it as ASCII delimited, you would get it into Excel easier...
>
>-Michelle
Well , Have you guys try doing some SQL into a cursor with the fields
that you need and then do a COPY TO FILENAME type XLS.
sele field1, field2...etc INTO CURSORX FROM tabelx
use cursorx
copy to cursorxls type xls
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement