>how to do it, eg. I have the record from text file:
>1998111745687hello
>which mean '19981117','45.6','87','hello' (four field)
>they are type date(8),float(99.9),integer(99),chars(xxxxx)

create table imported ( dField1 d, nField2 n(4.1), nField3 n(2), nFIeld4 c(4))
append from TheFile.txt type sdf