ADO - Importing Form Controls from Excel to Access

  • Thread starter Thread starter OMIP
  • Start date Start date
O

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
 
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
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top