Macro to delete import error tables

[fasternu]

Is there a way to run a script to delete all import error tables? There has a been a couple mention of this topic in this forum but I haven't been able to get the code to work for me. Any help would be appreciated. thx

 

[captnk]

Good Luck!
I posted a similar quesrtion a while ago and did not get a satisfactory response.
Fotunately I was generating the same number of error tables per import,(10),so I simply wrote a macro to delete the 10 tables.
I think this could be a problem if u generated a random number,because the macro defaults to debug if it cant find one of the tables.

In the second case I had I managed to fix the problem (usually text/number or date) or vice versa,but that was a lucky find
Its a real pity u dont seem to be able to use a wildcard on this,as it would be useful because the errors did not effect the final result
Captnk

 

[Mile-O]

I think that the Import Error tables are giving the same name with an incremental number to identiy them.

You could write a bit of code to go through each table and look at its name.

For Each Table In TableDefs
If the Left(tdf.Name,<whatever length>) equals "ImportError" then
delete the table
End If
Next Table