Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Convert from dbf to text
Message
 
 
À
19/08/2007 09:19:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01249004
Message ID:
01249026
Vues:
16
>hi all,
>
>i try to convert dbf to text file as this code,
>
>
>
>CLOSE all
>thisform.text1.value=GETFILE('dbf')
>USE alltrim(thisform.text1.value) in 0
>
>gcDelimName = ALIAS( ) + '.txt'
>gcDelimFile = PUTFILE('text_file:', gcDelimName, 'txt')
>IF EMPTY(gcDelimFile)
>   CANCEL
>ENDIF
>COPY TO (gcDelimFile)    && Create not delimited file
>COPY TO (gcDelimFile) TXT  && error
>SET DEFAULT TO d:\yousef
>
>
>thanks

Try either

COPY TO (gcDelimFile) TYPE SDF

or

COPY TO (gcDelimFile) TYPE CSV

or

COPY TO (gcDelimFile) DELIMITED
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform