Drop row in Access 2003 table 1

[vamoose]

I am wondering how to delete a row in an Access table if all the column cells are empty. For example, to drop the column I use this:
DoCmd.RunSQL "ALTER TABLE SAP_Import DROP COLUMN [F10]"
Is there something similar to drop an empty row ?

Thank you

 

[PWise]

See

Delete * from TableName where

 

[vamoose]

The table consists of a row/record of data then another row/record of data with an empty row/recond in between seperating the data. I want to delete the entire row of empty data not the data itself.

 

[PWise]

if you 100% for sure that on the rows that have data 1 field is always filled

then

docmd.runsql "Delete * from TableName where fieldnamd is null"