When trying to import an Excel file into Access I get a
message that the Action Failed. It lists the following
fields- Macro:Import_corp_Cust_list; Condition:True;
ActionName:DeleteObject;Arguments:Table,Corp_Cust_List,Loa

I am using Access 97 with a major query/report/macro
database written by someone 5 years ago that has
disappeared from the face of the earth.  It generates
sales reports from Solomon software each month.

How do I create a macro that imports an excel worksheet and appends a table?