Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Putting a txt file into a dbf
Message
From
16/08/2006 10:05:56
 
 
To
16/08/2006 09:27:10
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01145972
Message ID:
01145989
Views:
17
>Hi all,
>
>i have a problem. I have a txt file that i have to put into a dbf. Each line in the txt file is a new record in the dbf.
>
>my txt file looks like this :
>
>version = 2
>03
>00
>01/02/09
>09:35
>xyzadr test
>55
>
>result is like this
>dbf = mydef
>record 1 = 'version = 2'
>record 2 = '03'
>record 3 = '00'
>...
>
>Does anybody knows how to handle this problem ?
>
>thnx

try
SET TEXTMERGE TO "thetext.$$$" NOSHOW ON
\\version = 2
\03
\00
\01/02/09
\09:35
\xyzadr test
\55
SET TEXTMERGE TO

CREATE CURSOR importtext (f1 V(254) NOT NULL)
APPEND FROM "thetext.$$$" SDF
BROWSE
Previous
Reply
Map
View

Click here to load this message in the networking platform