Delete Import Error tables? (1 Viewer)

[captnk]

I am getting a number of Import error tables as the result of importing from an excel file.
Depite these tables being generated I am getting the correct answers imported into my access table,so rather than spend heaps of time trying to correct it,I really just need some suggestions to auto delete this growing list of useless tables.
I have tried a number of VB options .but because of their "variable numbering" I am having some trouble referencing multiple tables...The wildcard * before and after doesnt seem to work
Help Please
Captnk

 

[llkhoutx]

The data in your excel file is not formatted consistently. For example, some field may appear to be numeric, but are actually text.

I'd copy and paste special (to value) the apparent numeric columns in the spreadsheet, to be certain they're numeric. Note that the format of the first row of the spreadsheet, determines the format of all subsequent rows being imported.