Figured it out - all it took was a little bit of investigation. I appended the text file to a table with a number of fields using:

Append from MyTextFile.txt type SDF - works like a charm



>Thanks for the response. I have never appended a table from a text file that had more than 250 characters per line. How would I go about appending a table with six 250 character fields from a text file with 1464 character lines? Any assistance would be appreciated.
>
>
>>John's methods will work, of course, Allan. However you might just wish to make a temporary table with 6 250 char fields. Your data will append across all 6 and you can slice/dice just as you did before.
>>
>>Obviously if 250 comes in the middle of a field you can adjust it....
>>
>>HTH
>>Barbara
>>
>>