Ashank4vba
Programmer
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.
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.
