rajendra prasad-377679 (2/16/2012)

---

hi brother this is very very simple , for to do this u have to do little bit work in Excel.. just follow my steps..

1.copy the content in Excel file and go to data--text to columns--select the delimited options-->next-->select the COMMA--give next --and give finish..now u get the perfect format in excel .save the file format in old version 97-2003 format

if u need column heading pls include manually or else leave it and save it in your path .

note : if you include heading you no need to create table in sql server

if you are not include the heading u have to create the table structure..i am going to do easy format.my data contain heading in excel ..

now go to Sql server 2005-- Right click the database --choose the tasks-->importdata--next--choose the datasource-->microsoft excel--browse your file--check the first row has acolumn name---next-->choose destination as SQL native client--sever name --username and password--next --select copy data from one or more tables or views--select the sheet no which the data contain--and select the destination

[ReportServer].[dbo].[Sheet1$]--edit as [ReportServer].[dbo].[mydata]--next--check execute immediately--finish.

u have got one message the executon was successful..

go to sql server 2005 and check the table ..

EG : select * from reportserver.dbo.mydata

thank you ...