It is possible to automate Access from Excel using VBA code, this woukld allow you to run any queries, also those containing user defiend functions. So you could run a query to empty the tabel and ...

A missing value can lead to confusion by returning error values. But a properly used Nz() function can turn an error message into an understandable and expected value.