Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    55

    Unanswered: Removing Empty Records

    I have parsed data out of text file and exported it to Access. However, if there is a LF I get a empty row/record. How do I get rid of that empty row/record? I have tried DELETE * FROM [PL-03] WHERE [FIND NO] = 'NULL' ; but that did not work.


    Thanks,

    Animaul

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    DELETE * FROM [PL-03] WHERE [FIND NO] IS NULL


    S-

  3. #3
    Join Date
    Nov 2003
    Posts
    55
    Thanks, got it. I set the field as required and it worked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •