Sorry for late answer but like the way we do in crystal reports. We put fields in the asp.net forms and when the report is generated, the fields appear in...

Thanks all for replying. I did like this.

UPDATE e1

SET e1.empname = e2.empname,

e1.number = e2.number,

e1.city = e2.city

FROM emp1 as e1

JOIN emp2 as e2 on e1.empid = e2.empid

INSERT INTO emp1 (empid,...

But inner join maps only the rows that are matching in the two tables. I also want to update those rows that are not in emp1 but in emp2.

I tried two methods. First the native datatype was General. So the numeric data posted becomes text. Second, I converted the datatype of first cell, where the numeric will come,...

I am making a variable in which I call the OPENROWSET. @query has the select query from a table. @filepath contains the pre made excel file which will be used...