how to convert excel file into database in sql server2005?

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