Dear Team,
Hi.......
Today I came to know about this forum. I am new to this lang.
I want to connect to oracle database using VBA. can anyone help me the simplest way to write macro. I googled but not getting proper solution.
Connection to db--> Username=scott password=tiger server=oracle.

I want to retrieve data from database using sql code below

select e.ename,e.deptno,d.dname, b.percentage
from emp e, dept d, bonus b
where e.deptno=d.deptno
and e.sal=b.sal