Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to read contents of many txt files into my cursor
Message
 
To
18/05/2004 05:16:39
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00904823
Message ID:
00904829
Views:
11
Are the txt files, has the same format?
If so:
 CREATE CURSOR cCursor (.......) && Here you can specify the format of the txt
 all_txt = ADIR(my_array,"*.TXT") && You can put the fullpath to txt files
 FOR nFile = 1 TO all_txt
     txtFile = full_path + my_array[nFile, 1] && You must put the fullpath to txt file
     APPEND FROM (txtFile) SDF [DELIMITED] && See help for more
 NEXT
Othe way is to read the txt file one by one into variable & process that variable to append the cursor
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform