Well, for #1 - just paste this function into a STANDARD module (not a form, report or class module) and then you can call it easily from your macro:
Code:
Function DeleteImportErrTables()
Dim z As Integer
Dim db As DAO.Database
Set db = CurrentDb
For z = db.TableDefs.Count-1 To 0 Step -1
If InStr(1, db.tblDefs(z).Name, "ImportError") > 0 Then
DoCmd.DeleteObject acTable, db.TableDefs(z).Name
End If
Next z
End Function
In the macro just use the
Action: RunCode
and in the function name just put
DeleteImportErrTables
As for the second part - I'm not sure I am understanding what you mean there.