Dear  Sir/Madam,
                          I am planning to import Excel 2007 data into my Database. As of initial work I am reading excel sheet data into DataTable using OleDbDataAdapter . But the problem is I am unable to read CheckBox controls data into my dataset. It is showing empty values for check box fields . I am sharing lines of code I am using.

 DataTable dtTrainers;
 dadVET = new OleDbDataAdapter("Select * From [SheetName$]", myConnection);
 dtTrainers = new DataTable("TrainersAndAdminStaff");
dadVET.FillSchema(dtTrainers, SchemaType.Source);
 dadVET.Fill(dtTrainers);

Please if you have any idea update solution asap.

Thanks & Regards,

T.Hari babu
E-Mail : [email protected]