Deleting data from a table is easy. The VBA would be something like
Code:
Currentdb.Execute "DELETE * FROM tblImport1;"
Currentdb.Execute "DELETE * FROM tblImport2;"
etc......
You can manually import the sheets and save the import specs, but editing the specs if the Excel file name changes or the path changes is very difficult.
You basically have to manually import the sheet again (saving the spec) for each worksheet.
You will have to run each saved import to import the 4 sheets.
See https://support.office.com/en-us/art...042BDDB640#bm2
As an alternative you might look at Ken Snell's site for an all Access method:
http://www.accessmvp.com/kdsnell/EXCEL_MainPage.htm