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