importing control values from excel to access

[Ashank4vba]

Hello,

I am trying to import data from a questionnaire (excel file) into access tables. The questionnaire contains controls (checkboxes, comboboxes, option buttons etc).
I would like to know the best way to import all that data to Access.

I can use DoCmd.transferspreadsheet function to import data in cells by using their ranges in excel. For this, I can store the ranges of all 'answers' and individually 'transferspreadsheet' each answer (by specifying 'range_x:range_x'). However, I'm don't know yet as to how to get the answers that come in controls in the excel file (option buttons, checkboxes).

Please help! Thanks.

 

[Ashank4vba]

I guess I don't need to use transferspreadsheet. I can just create excel objects and work with them and hopefully I can access controls with them.

 

[Ashank4vba]

<option button name here>.Value works

-4146 means that it is not selected!
1 is selected.