XPost: alt.comp.lang.vb, alt.comp.lang.visualbasic, microsoft.public.access   
   XPost: microsoft.public.vb   
   From: me@you.com   
      
   Hello,   
      
   I have a text file that has a one character column in it.  In some records,   
   this column has an "S" in it, or else it is blank.  I'm trying to import   
   this file into an Access database using VB.  The table that I'm importing to   
   uses this column as part of the primary key.  Because of this, the records   
   that contain a blank in this column, aren't being imported.   
      
   My question is; is there an easy way to update this text file directly,   
   where if the column is blank (space) then update it to use a specific   
   character?  Or, is there a way to import this file and ignore the blank?   
      
   Any help would be greatly appreciated.   
      
   Thanks!   
   Rick   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)