Hi All,
I have been trying to download SQL Scripts through excel. It was successful at first but when I tried to run the below script it prompts a Datatype not supported error.
I am using an ADO connection for this.
Below is the code to call SQL script.
Dim sql As String
sql = ThisWorkbook.Sheets("Scripts").Cells(2, 7)
Call GetDataFromADO(sql, ThisWorkbook.Sheets("temp").Range("p2"), Sheets("temp"))
Sheets("temp").Select
and here is the SQL script.
<colgroup><col></colgroup><tbody>
</tbody>
Kindly note that when the above script is run via Oracle developer it does works.
Thanks in advance.
Ron
I have been trying to download SQL Scripts through excel. It was successful at first but when I tried to run the below script it prompts a Datatype not supported error.
I am using an ADO connection for this.
Below is the code to call SQL script.
Dim sql As String
sql = ThisWorkbook.Sheets("Scripts").Cells(2, 7)
Call GetDataFromADO(sql, ThisWorkbook.Sheets("temp").Range("p2"), Sheets("temp"))
Sheets("temp").Select
and here is the SQL script.
Select PERSONPERMID,COMPANYNAME,COMPANYTITLE |
from PEOPLEAUTHORITY.PERSONINFOFORCONCORDANCE |
Where PERSONPERMID in (00000000) |
<colgroup><col></colgroup><tbody>
</tbody>
Kindly note that when the above script is run via Oracle developer it does works.
Thanks in advance.
Ron