Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Convert to excel
Message
De
08/09/2005 18:46:29
 
 
À
08/09/2005 17:27:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Divers
Thread ID:
01047848
Message ID:
01047915
Vues:
11
Try
COPY TO (gcDelimFile) FIELDS f1,f2,f3,...fn  XLS
>hi,
>thank you,
>i try via vfp help as
>When the field list specified using COPY TO...FIELDS does not include the field that uses autoincrementing.
>
>i don't understand what i must do
>
>but i try as under, iget error messages
>
>COPY TO fields (gcDelimFile) XLS && error message Invalid path or file name
>
>COPY TO (fields) XLS && error mesage Variable "fields" is not found
>
>COPY TO (gcDelimFile)fields XLS && error mesage Variable "xls" is not found
>
>COPY TO (gcDelimFile.fields) XLS && error mesage "gcDelimFile" is not an object
>
>
>thanks.
>
>
>
>i try as
>>>hi all,
>>>
>>>any idea ,to convert mytable to excel book,
>>>
>>>just fields have data only,
>>>this code under convert all fields
>>>
>>>USE am2
>>>*GETFILE()
>>>
>>>gcDelimName = ALIAS( ) + '.xls'
>>>
>>>gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')
>>>
>>>IF EMPTY(gcDelimFile)  && Esc pressed
>>>   CANCEL
>>>ENDIF
>>>
>>>COPY TO (gcDelimFile) XLS   && Create delimited file
>>>
>>>
>>>
>>>thanks.
>>
>>Check COPY TO command in Help. This command has FIELDS clause.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform