Deleting Blank Records Automatically

[Xcalibur]

When I import an excel spreadsheet into my Access database it always creates a couple of new blank records. I import this spreadsheet frequently so I would like to set up a macro that will automatically delete any blank records it creates. Can someone tell me specifically how to do this?

Thanks.

 

[tehNellie]

after you've done the import, run a query along the lines of:

DELETE FROM tablename WHERE columnname IS NULL;

 

[Xcalibur]

Thanks, I will try that tomorrow!

 

[Xcalibur]

Thanks, I will try that tomorrow!

I created a delete query and added it to my macro to run it. Works great. Thanks!