Hi: Can any one please tell me how to i create a table so that it will create 5 fields (One for auto number) and then fill the below records into it.Thi is basically a text file name "CCBK0607.txt". I try it but dont know how to i create 5 fields.

drop table #four;
CREATE table #four(fourCNTR integer default AUTOINCREMENT , wholestring varchar(1510));
input into #four (wholestring) from 'C:\myfiles\CCBK0607.txt';

4 20070306 B13 Received Bankruptcy Information Hongco Management - 800-801-3122 4227097378942085
4 20070306 B7U Received Bankruptcy Information Hongco Management - 800-801-3122 4227093007615234
4 20070306 B13 Received Bankruptcy Information Hongco Management - 800-801-3122 4227093011512286
4 20070306 B7U Received Bankruptcy Information Hongco Management - 800-801-3122 4227093821535410