Can you use a temp table that has no constraints or rules? Maybe need
different column names. Then just xfer the data you want.
I think "humongous" (or some spelling of it) is a word.
Doug
Bernard Lis wrote:
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
