I use both Visual Basic and Visual Basic for Applications. In VB I have a
component (Microsoft ADO Control) that can activate and then dim

dim con1 as ADODB.connection

and then select data from my SQL database.

In VBA, there isn't a "Components" selection, only "References". Yet
through various posting on these sites I have seen VBA (Excel) code that
creates the same dim reference.

How do I get VBA to recognize the Microsoft ADO Control?