how to convert and insert from excel to sql server

See more:

SQL

server

i am having so much of records in excel sheet, how to insert these all records into sql table?

like following coding use for it

SELECT * INTO XLImport3 FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\test\xltest.xls;Extended Properties=Excel 8.0')...[Customers$]

SELECT * INTO XLImport4 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\test\xltest.xls', [Customers$])

SELECT * INTO XLImport5 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\test\xltest.xls', 'SELECT * FROM [Customers$]')

//what i am using this place-----[Microsoft.jet.OLEDB.4.0] actually i am not using OLEDB CONNECTION, I used SQL Connection.

please check and explain me.

[EDIT]Unchecked option: "Treat my content as plain text, not as HTML"[/EDIT]