Please can someone help with this. I'm new to using VBA and i wanted to find a way to copy a table from an SQL server into my microsoft access table
here is what i did ( i'm familiar with doing in excel but the data is HUGE!)
Sub test()
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim SQL As String
cnn.Open "Provider=MSDAORA;Password=xx;User ID=xx;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOC OL=TCP)(HOST = xx)(PORT = xx)))(CONNECT_DATA=(SID=xx)));"
SQL = "SELECT lotnumX FROM InvTable "
rs.Open SQL, cnn, adOpenForwardOnly
End Sub
what i dont know is how to take the SQL and copy into a table i have in my access