sarat
07-04-2012, 06:06 AM
Hi all,
I am very new to this field. I want to connect to oracle through VBA and retrieve data from table. I referred so many link but still not come to a final conclusion.
I am really frustrated. Can anyone provide the code.
I have select ADO object from tool-->Reference-->microsoft activex ADO 2.1 Object Library using odbc connection.
<-------Information---->
Data source name--jai
Username-scott
password----tiger
server---oracl
I am very new to this field. I want to connect to oracle through VBA and retrieve data from table. I referred so many link but still not come to a final conclusion.
I am really frustrated. Can anyone provide the code.
I have select ADO object from tool-->Reference-->microsoft activex ADO 2.1 Object Library using odbc connection.
<-------Information---->
Data source name--jai
Username-scott
password----tiger
server---oracl