I’ve been beating my head against the wall for far too long on this.
What is the code to connect to an Oracle table through Visual Studio 2019 – using Visual Basic?
On a form load event, I want to connect to Oracle, and import the data from a specific table and then paste it into a new Excel file.
Public Class ImportForm
Private Sub ImportForm_Load(sender As Object, e As System.EventArgs) Handles Me.Load
Dim conn As New OleDbConnection(“Data Source=188.8.131.52:1521;User Id=test”) ‘fake data
(select data and put into Excel)
Any help would be much appreciated!