Home > Forum Home > Automating Data Analysis Tasks > Using Excel to connect to AS400 database to retrieve data > Mixing ODBC with ADODB Share

Mixing ODBC with ADODB

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


Forum TopicLogin

Mixing Odbc With Adodb

Rate this:
(3/5 from 1 vote)
SurprisedIt 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 on
 
View Full Post

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