Is it possible to export and delete tables (not records) with VBA code?

I want to do this because I dont want the user hassle with importing the table to the database but rather just by a click of a button. Same goes for deleting tables.

Thanks in advance.