Use the Data Transformation Services / Wizard. Look it up in BOL (MS SQL Servers help file).

This makes it as easy as it can be (which depends on the complexity of the data, it's data types, quality of the Excel data etc).

HTH,

Peter