>I use to receive TXT files which the first line belongs from another table
>I have three questions about this issue
>
>1-Is it possible to skip this first line when appending or I really must treat it after importation already in DFB ?You can use FOR clause to filter out unwanted records
>2- It's not delimited and I am using SDF type, is it correct ?It's correct if file has fixed layout
>3- It there any technique to import directly to date, numeric fields or do I have to import all to character fields and then transfer them to another tableIf date is in the format YYYYMMDD than you can import it directly into a date field. You shouldn't have problem importing numeric data into the numeric fields.
--sb--