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
>
>
>>Hi,
>>
>>I have to find a way to import a text file into a table. The problem is that each line in the text file is 1464 chars. With other text files I have worked with - which were less than the max. field length of 254 chars - I simply imported the file into a table and started slicing and dicing the data.
>>
>>Any ideas on how I should go about importing a file with more than 254 chars per line?
>>
>>Thanks, Al