I have an ascii file with currency values, 1 value per row.
There are 64,000 + rows in the ascii file - only 40 of them have data. The rest are null

How can I get rid of the null rows before loading them into the table?

If I load them with null rows I keep getting the message that it cannot be null even if messages are off. This means I have to press ok 60,000 + times. If I eliminate not null constraint, The database gets humongus (is there such a word).

Any ideas?

Bernie Lis

Reply via email to