Populate data from SQL Server into excel
Posted on 2011-03-10
I need to populate datafrom SQL server to excel in some specific cell.
I have done that using ADO.NET.
But I am stuck in populating data into check box.
The criteria is :
There is a status flag in a table. The value of that be 0 or 1.
That field value will be populated into a check box field in excel. The tick mark will be put in the excel check box if the field value of the database table is 1.
Please help me.