Mixing ODBC with ADODB

Excel Help for Mixing Odbc With Adodb in Automating Data Analysis Tasks

Forum Topic

Rate this:

(3/5 from 1 vote)

It seems that you need to replace:

VBA Code:

Dim cnnConnect As ODBC.Connection

With:

VBA Code:

Dim cnnConnect As ADOBC.Connection

You will also need to make this change with the declaration of the Recordset object.

Excel Business Forums Administrator

Posted by Excel Helper on 26 Dec 2010

Find relevant Excel templates and add-ins for Mixing ODBC with ADODB in the Excel Business Solutions Directory