Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing data from fixed width files
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00562162
Message ID:
00562163
Views:
18
This message has been marked as the solution to the initial question of the thread.
>I have a dbf table with no records and it's structure matches a fixed width text file. Meaning, for example, if field1 is a c(6) and field2 is a c(10) then, in the text file, columns 1-6 are field1 and columns 7-17 are field2.
>
>What would be the best way to import this data?
>
>TIA
SELECT mytable
APPEND FROM myfile.txt SDF
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform