Here's a simple solution:
---
DoCmd.RunSQL "DELETE * FROM <<enter table name>>;"
DoCmd.TransferSpreadsheet acImport, <<enter spreadsheet type ie. acSpreadsheetTypeExcel9>>, "<<enter table name>>", "<<enter directory path where spreadsheet is stored>>", True, "<<enter spreadsheet range if...