Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 541
  • Last Modified:

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,
0
sam000
Asked:
sam000
1 Solution
 
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now