You have two ways of doing it.
1. The easy and simple way i.e to use the Import Wizard provided by the SQL Server.
2. Use the OPENROWSET command.
INSERT INTO [tableName] ([C1], [C2], [C3], [C4])
SELECT DB.[C1], DB.[C2], DB.[C3], DB.[C4]
FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\testDB.xls;HDR=YES', 'select * from [Sheet1$]') AS DB;
I personally prefer the second method. Though it looks little complecated its the best way of doing it.
BR//
Harsha Narayana