Delete all blank records

[Guest]

I have an Excel spreadsheet that I transfer into a database each week. The
range that contains data always varies (it is over written each week by
another department.) so it would not be practical to specify the range to
import in Access or delete the rows Excel sees even thoughthey don't contain
data.

Is it possible to record perhaps an update query that will delete all blank
records? I'm currently using a macro to import the data, could I also
specify that after it imports the data it automatically delete all of the
extra records.

 

[Guest]

Depending of what you mean by empty field ( a zero string lengh or Null
value) you can use a delete query that search for empty field.

Post your table structure if you need more details.

Yanick