Select record with blank in specific column

[dapfeifer]

Hey everyone,

I'm working in a database with gets its data from a text file, then assigns values in a blank column to the imported data once imported. The problem is that once I start the import process for another file the recordset starts back at the beginning of the table and I overwrite the data from the first import.

I am using a DAO recordset, so does anyone know how to move to the record that has a blank in the specific column I need to push data into?

If I need to clarify what I'm asking, please say so.

 

[MarkK]

Say field1 in table1 has null values in some records. You can fill a recordset with only those rows like this...

dim rst as dao.recordset
set rst = currentdb.openrecordset( _
  "SELECT * " & _
  "FROM table1 " & _
  "WHERE IsNull(field1)")
with rst
  do while not .eof
[COLOR="Green"]    'do processing on those records here[/COLOR]
  loop
  .close
end with

 

[dapfeifer]

Thanks for the input! I had to work with this a bit, but ultimately it pointed me in the right direction for getting done what I needed. Thanks again!