Connect to Oracle Database using Excel VBA

[User17061968]

Hello all, hi Deepak,

my further question:

Using EXCEL 2016) and the link "Microsoft Active Data Objects 6.1 Libary" (msado 15.dll), I get an error in the fouth line:

Sub Option4()
Dim SQL_String As String
Dim dbConnectStr As String
Set con = New ADODB.Connection

< Information of EXCEL: Variable is not defined. What's to do?

Thanks for infromation

Regards

JuMathias