Sql Server integration services will let you (among many other things) read from Excel and insert into a table. The Import Wizard will even generate most of what is needed for you.

I suggest you have a read about both in Books On Line and come back with specific questions if you have a problem.

Mike