Delete blank rows

[Pitou]

Is there a way to delete blank rows in an access table ?
Data are imported each week from an Excel file, and to
automate the process to the max, +/- 3000 lines are
imported each week, but some of them remain empty.
I would like to "clean" the database table by removing
them.

What is the best way ?
Maybe create a delete query ???

 

[Guest]

Works.

-----Original Message-----
A delete query will be in fact the best way to do it fast. Put "Is null" as
criteria, test to see if it bring the right record then convert it into a
delete query.

Yanick


.