There are a number of ways I think but probably the best is to use ASP
to read the Excel file and write to your Access table ignoring blank
rows.

Another is to have an Export button in Excel to export a text file and
an import  button in Access to read it into a table and ignore blank
rows though that's only semi "automatic"... still better than running
the import wizard though :-) I gather that's what you're doing
now???