Populate data from SQL Server into excel

Hi,

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.
Regards,
sam000Asked:
Who is Participating?
 
SiddharthRoutCommented:
See this link

http://support.microsoft.com/kb/306125

And when you have the relevant data then simply incorporate this code.

Checkbox1.Value = Field1

Sid
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.