ADO - Importing Form Controls from Excel to Access

[OMIP]

Hi,

I am trying to import data from Excel to Access using ADO.
Everything works fine as soon as standard cell values are concerned.
But I've got problem with importing values connected with Form Controls
appearing on Sheet.

How to import e.g. OptionButton value using ADO?

Thanks.
Christian

 

[John Nurick]

Hi Christian,

If I understand you right, you'll need to either

-link the controls to cells in the worksheet, or

-use Automation and the Excel object model to access properties of the
controls themselves.

Hi,

I am trying to import data from Excel to Access using ADO.
Everything works fine as soon as standard cell values are concerned.
But I've got problem with importing values connected with Form Controls
appearing on Sheet.

How to import e.g. OptionButton value using ADO?

Thanks.
Christian

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.