VBA connecion strings for Teradata SQL assistant .NET or ODBC.

Connectivity
Enthusiast

VBA connecion strings for Teradata SQL assistant .NET or ODBC.

Hello Experts,

 

I am trying to get the results of a query from Teradata SQL assistant into a table in Access , I am using the following script and I think I am not using the correct arguments for the connection string.

Can someone point out the connection strings for .NET connection or ODBC connection with Teradata SQL Assistant.

 

'Access script to connect to Teradata
Sub importquery()
Dim strConn As String

strConn = "Driver = odbc_connection_name ; Persist Security Info = True; Data Source=view_name ; Integrated security= True;"


Dim Query As String
Query = "select statement"

Dim rs As New ADODB.Recordset
rs.Open Query, strConn

Sheet1.Range("A1").CopyFromRecordset rs

End Sub