The 'truncate table' command will delete all the records from a table and reset the identity if there is one. And yes it is possible to import records from an excel file automatically. You will nee to create a DTS package to do it and then schedule that to run on a weekly basis.

>Isn't there a way to delete all records from the database in one shot?
>what about th rest, is it possible to schedule a import routine frm an excel file?