Hi,
I am trying to export data from excel sheet to a table on a oracle database but couldn't get the code below to work
It keeps throwing error at 2nd strSQL line. I seek help from forum to get this to work. thanks.
Sub ExportXLtoOracle()
Dim con As ADODB.Connection
Dim conStr As String
Dim...