Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fields' names converting Excel into DBF
Message
 
 
To
13/09/2006 05:02:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01153213
Message ID:
01153243
Views:
30
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform