Brother, starting from the beginning that Oracle is installed and working, I recommend that if you are using VBA in Excel: Point to Tools and Reference, check the option: Oracle Data Control, this post insert the code below with your user and password of your Bank:
Select all
Private Sub Command1_Click()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.CursorLocation = adUseClient
cn.Open "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=orcl;uid=scott;pwd=tiger;"
rs.Open "select * from emp", cn
MsgBox rs.RecordCount
rs.Close
cn.Close
End Sub
Now if you are using VB by Visual Studio is much more practical, just click on the Date menu and add a new Data Source that the same goes from Next and Next until the end .
Well, that's it, I hope I helped you.