Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to read a text file and add its data in a table ?
Message
 
To
02/02/2007 17:20:19
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01192017
Message ID:
01192117
Views:
16
>the text file has fixed field lenght
>12 + 60 + 12 + 20 caracteres with no delimeters. i want to read each line and after some tests append in a table.

1) Create a table that matches the data in the text file for field data type and length.
2) Open that table
3) APPEND FROM TextFile TYPE SDF
4) Process the data for your your tests
5) Take the data from the table you appended to and put it in the actual final table it needs to be in
Previous
Reply
Map
View

Click here to load this message in the networking platform