Hi, I have tried to execute the below command from macro Code: Sub abc() Dim conn As New ADODB.Connection Dim rs As ADODB.Recordset Dim query As String Set con = New ADODB.Connection Set rs = New ADODB.Recordset strcon = "Driver={C:\Program Files (x86)\Vertica Systems\lib\vertica_6.0_odbc_3.5.dll}; ...

Hello ,

I have fond a very useful article about how to connect to vertica from excel.

My requirement is to execute sql query which stored in excel cell value in vetica DB
Any idea on how to do that ?