Giganews Newsgroups
Subject: ADODB
Posted by:  Richard Mogy (rmo…
Date: Thu, 06 May 2004

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?