I have few fields with checkboxes on my excel form, that I would like to read into access..
MyRecFields("Level_One") = xlsx.cells(17,"B")
MyRecFields("Level_two") = xlsx.cels(18,"B") and soon.
In the access table I have these fields as yes/No
When read the excel file all these check boxes are downloaded as blank instead of checked.
Thank you