Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert text file
Message
From
14/05/1998 09:21:59
 
 
To
14/05/1998 09:15:14
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00099378
Message ID:
00099391
Views:
19
>>>How could I convert a text file to Dbf file without using Import Wizard?
>>>
>>>The text format is defined each field name's length, start byte, and end byte.
>>>
>>>Ex. FieldName Length Start End Byte
>>>
>>> Field1 1 1 1 1
>>> Field2 8 2 9 8
>>> Field3 40 10 49 40
>>> ....
>>>
>>>Thanks
>>
>>I guess you have fixed-length ASCII file and you can prepare table structure and use APPEND FROM ... TYPE SDF.
>
>Do I need to create a table with the same structure as the fixed-length ASCII file before I do the append file command?
>Could you list a bit more details?
>
>Thanks

Yes, firstly you create table with identical structure. BTW, import wizard can do this job for you.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform