Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import from excel to vfp
Message
De
25/06/2006 17:03:34
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
25/06/2006 08:24:56
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:
01131502
Message ID:
01131580
Vues:
15
>hi all,
>
>any idea, help
>
>when i make import from excel to dbf
>
>fields name as(no,name, telno,customer no...) change to a,b,c,d...
>is ther away to keep the names as it is at dbf
>
>IMPORT FROM (thisform.text1.value) TYPE XLS
>
>
>thanks

I don't know how to do this with the "import" command, but you can open the spreadsheet in Excel and save it in DBF format. Of course, this can be automated (Automation from VFP).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform