Deleting "ImportErrors" table created during Excel file import

[SQSunshine]

My code imports an Excel file when the user clicks on an "Import" button. This works great, except that a "import errors" table is automatically created by Access during the process. Does anyone know what code I can use to delete the table that is created? I have used the DeleteObject method to delete tables that I have created; however, the same code doesn't work on the "import errors" tables. Thanks for any help you can give me.

Susan

 

[SkipVought]

Hi,

You're not at all concerned about the missing data?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[MazeWorX]

Assuming Skips question doesnt concern you

    DoCmd.SetWarnings False
    Dim tbl As AccessObject

    For Each tbl In CurrentData.AllTables
        If tbl.Name Like "*_ImportError*" Then
            DoCmd.DeleteObject acTable, tbl.Name
        End If
    Next tbl
    DoCmd.SetWarnings True

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work

 

[SQSunshine]

To answer Skip's question...no, in this particular case, missing data doesn't concern me. I tried your code, MaZeWorX...it worked beautifully!!! I can't thank you enough!

Susan

 

[SkipVought]

I guess that Florida sunshine, makes all the problems melt into orange juice.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]