Overwriting data in access table when importing from excel

[JustAsking]

Hello,

From within Access, when I use the wizard to import data from an Excel spreadsheet to a database table, I am trying to work out if the contents of the table can be deleted when the data from the excel spreadsheet is imported. Can anyone shed some light on this question?

Thank you.

 

[Not A PHB]

I believe the contents will be overwritten with each import unless you link the spreadsheet and append the data through a query. If you would like the data overwritten each time you can delete the contents with a delete query and then append the new data from the spreadsheet all this can be done in code or a macro.

Thanks,
Lance