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]

Using Excel Application object in vba now...hopefully things will be easier.