Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fields' names converting Excel into DBF
Message
 
 
À
13/09/2006 05:02:19
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
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01153213
Message ID:
01153243
Vues:
31
You can use FIELD() AND FCOUNT() to loop through the fields and ALTER TABLE to rename fileds.

>
>is there away to change fields name a,b,c,d....
>
>with first records data after import command
>
>
>fileds name  a         b     c        d ......
>rec.1       num       name  sala       .......
>
>
>
>thisform.text2.Value=GETFILE('xls')
>IMPORT FROM (thisform.text2.value) TYPE XLS
>
>use JUSTSTEM(thisform.text2.value)
>
>replace filed A with (first culomn  data)
>replace filed b with (second culomn  data)
>replace filed c with (therd culomn  data)
>replace filed d with (...................)
>.
>.
>.
>
>
>thanks
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform