Help needed for creating Dynamic Oracle Query using Excel VBA and Forms

vijaysram

New member
Joined
Jun 19, 2013
Messages
6
Reaction score
0
Points
0
Presently,I am using the method : Data--> From other Sources --> From Data Connection Wizard --> Others/Advanced--> Microsoft Provider for Oracle to run a Query on Oracle Database and Storing the Data in the Excel Sheet.
I am having a requirement to Use Forms to Get the Data from the users and want to run the Dynamic Oracle query and want to return the Data in the Form

Ex: Select * from Employee_Database where Employee = 'Ravi' and Department = 'HR'

In the above Query, I want to get the Employee name and Department from the users using Forms and want to run a query in Oracle database and return the value in Forms.

Please let me know if this can be automated completely using VBA , Forms and Dynamic Oracle Queries. If so, Please assist me how to do it as i am new to VBA programming.
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,200
Reaction score
16
Points
38
Excel Version(s)
365
For information, cross posted at vbaExpress and mrexcel (sorry my post count is less than 5 so can't post exact links).
 
Top