Hello, I am trying to connect an Access database to Teradata DB. I am trying to import the data from a teradata table into a access Table. The table should also be able to insert data into the Teradata DB.
I have been able to set up a connection to the Teradata DB using the following code, but an unable to insert the data from the teradata table to the Acesss Table ( Access Table is a replica of the Teradat Table, in terms of structure).
Dim cn As ADODB.Connection Set cn = New ADODB.Connection
Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset
Dim cmdSQLData As ADODB.Command Set cmdSQLData = New ADODB.Command