Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append to a new dbf file
Message
 
 
To
27/11/2010 05:56:39
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01490606
Message ID:
01490718
Views:
43
>hello Everybody, I did small program to append from a text fle I did not have a problem . the only thing if there is a possiblity
>that the first row will be the name of the fields and start appending from the second row. I am sure what I am saying I am seems little bit silly with this question but I saw it in the import wizard here is the code but I could not continue
>Thank's a lot
>

Try
macinv=getfile('txt') &&this is to get the text file

if not empty(macinv)
 select TableOrCursorToAppendTo
 APPEND FROM (macinv) DELIMITED WITH _ WITH tab FOR Recno() > 1
endif
BROWSE
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform