An easy to remove the nulls is to import the file into XL, sort and delete the rows with null.
The project table method is also easy. John Engwer -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Thursday, September 29, 2005 4:13 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Loading data into a table Ted, How do I replace a null row in a text editor or how can I just delete them? I tried in rbedit, but I got tired of holding down the F9 key to delete them. Bernie ----- Original Message ----- From: "Ted Wolfley" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Thursday, September 29, 2005 3:46 PM Subject: [RBG7-L] - RE: Loading data into a table Try opening in a text editor and delete the null rows with find and replace. Ted -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Thursday, September 29, 2005 3:37 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Loading data into a table 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
