How to read check boxes fields from excel form?

[stalk]

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

[Micron]

If the data is in the sheet why not just link to the sheet in Access like it was a remote table? If that doesn't help then I think you'll have to be more clear, including explaining what "When read the excel file" and "all these checkboxes are downloaded" means.

[June7]

I did a test of importing worksheet saved after entering data into cells via checkboxes. The values import as either True or False appropriately.

[stalk]

Micron, How do I link this form to access and read the data. This is kind of survey form to collect data.

June7, I could not read the checkboxes when they are checked. All he 4 are imported as blank

Any suggestions?

Thank you

[Micron]

I thought you meant you had a user form, which that isn't. If the data is on one of your tabs (sheet) then from Access ribbon go
External Data tab >New Data Source >From File> Excel >Browse >choose link option >ok
You will either have to choose a sheet that contains the values, or use the option to choose a range.

If your checkboxes are not data values, then what you have is akin to a picture of a coin and you are asking how to spend it. In other words, it's virtual and I don't know if you can or how you'd retrieve the values.

[June7]

The 4 checkboxes are not linked to cells. This means checking box does not save value to a cell. Data must import from cells. This is why no data imports to Access and Access yes/no field defaults to False.

[stalk]

Okay, Got it. will try linking the cells.
Thank you