Import data from excel file to Mircosoft SQL Server

Can anyone guide me how to import data from excel file to Microsoft SQL Server? My excel file just have the data, no column name.
Thanks.Use DTS ?|||Use DTS ?
Use DTS !!!|||Use SQL's Data Transformation Services. You can use the Import Wizard, which will walk you through finding your EXCEL file and importing it into an existing / new table in the database.

import data from .rpt file to SQL Server 2005 UsingSSIS

Can anyone guide me to import the data from .rpt file to SQL Server 2005 Using SSISWelcome to msdner!
Im going to move this to the SQL forum, you can get help there.

Please do not double post your questions.

Have a nice day!

--
Kestrel|||Hi sekaranus and Welcome to TSDN,

Can you confirm what application has generated the .rpt file ?

Regards Purple