0 - 1 of 1 tags for connection to teradata

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