I'm new to programming. I want to connect to a secured database and display some fields from a table in the secured database into an existing table in my access.
i have this so far but I just cannot figure out how to put this into a table called "MyTable"
Sub RetrieveRecord()
Dim SQL As String
Dim Conn As New ADODB.Connection
Dim mrs As New ADODB.Recordset
Dim DBPath As String, sconnect As String
sconnect = "Provider=MSDAORA;Password=;User ID=;Data Source="
Conn.Open sconnect
SQL = "select ABC, DEF, GHI from XXX"
Conn.Execute SQL
Set Conn = Nothing
End Sub