In a Python script, I'm cycling through thousands of Excel files and using arcpy.MakeTableView to create in memory table views from the first spreadhseet in each file. How do you delete the reference to the in-memory view? I've tried deleting the variable that stores the table name, but to no avail.
tblView = sheetName
arcpy.MakeTableView_management(excelSheet, tblView, .....)
## Process the table here
del tblView
The reason for deleting the reference is that in some cases the sheet names are duplicated in the Excel files. If a table view has been created with the name "Sheet1", you can't create another table view with the same name. In addition, due to the number and size of the Excel files being processed, I'm concerned about an impact on performance if all of those table views are preserved through the life of the script.