Results 1 to 2 of 2

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,480
    Articles
    0
    Excel Version
    365
    For information, cross posted at vbaExpress and mrexcel (sorry my post count is less than 5 so can't post exact links).

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •