Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Loading data from text files.....???
Message
From
22/06/1999 12:26:36
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00232388
Message ID:
00232555
Views:
20
Hi Bruce ---

>Also, I might guess that a lot of Replaces/Substrs like that would take longer on a large file...

Surprisingly, no. In the example I posted, I used APPEND and REPLACE just to "dumb down" the code...I hate masking the concept with overly complex example code. Generally, in the real world, I use INSERT INTO () VALUES (). The advantage to using low-level file interaction is that you can validate the data and structure of the file. Anyway, usually you have to massage the data into final form anyway, and not just do a direct import so it boils down to 1/2 dozen of one or 6 of the other.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform