Quote Originally Posted by Kenneth Hobs View Post
From the link that I provided for the connection strings, and your recorded macro, this connection string might work.

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;
Password=myPassword;

See this thread for an example.
Yes, I am now able to connect My Database.. I am now having the requirement to run a dynamic query.

Ex : In my database , if i am running a query : Select * from Employee_database ; there is a Field and it is returning some value A = 200 or some A = some numeric value.

I now need to get the input from the VBA form text box and need to run the dynamic oracle query

i.e. Suppose if i am entering text box value =100 it has to run the query : Select Employee_name, Value from Employee_database where value = 'A= ???'

Please advise further...