Hi John
No, there are no memo fields in the target table. I do think that I'm approaching the problem the wrong way though - I'm using the command
APPEND FROM TEXTFILE.DAT TYPE SDF FIELDS MYTABLE.Account_no, MYTABLE.Acc_name, etc etc
The problem is that the system trys to dump all the info into the first field "Account_no" and nothing into the next fields. I actually want the first 20 characters of the text line placed into field 1, the next 20 into field 2 etc...
It works fine when it's comma delimited, but not in the flat file format.
Regards
Chris
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only