How to automatically delete import errors table

Question

I am trying to import a report in excel format to access.  This report is generated daily.  The problem is when I import I get this Import Errors table which contains fields which do not have any data. I was just wondering if there is a way to automatically delete this table or to prevent this table from generating in the first place.  What I see happening is each day the new report is generated an error table will be gerneated and absent an easy automatic way to delete these error tables we will see an excessive amount of error tables and space taken up over time. 

Thanks,

Terry Carroll

Answer 1

Right now I am just using a macro linked to a command button. 

Thanks,

Terry

Answer 2

How are you importing the data? Manually? Using a macro? Using VBA?

You may be able to add a command to delete the table.