ADODB

  • Thread starter Thread starter Richard Mogy
  • Start date Start date
R

Richard Mogy

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?
 
Dim con1 As Object
Dim oRS as Object

Set con1 = CreateObject("ADODB.Connection")
Set oRS = CreateObject("ADODB.Recordset")

etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Great, I'm glad you understood my succinct response.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top