Consulting

Results 1 to 3 of 3

Thread: vba function to query oracle database

  1. #1
    VBAX Newbie
    Joined
    Nov 2017
    Posts
    1
    Location

    vba function to query oracle database

    Hi i am new to vba and i have this business requirement where a function (not macro) need to be created which makes connection with oracle database and query particular table where the query has where condition. It should be like if i enter the function in excel cell and the where condition(parameter) it should return the value.

    for eg: =getdata(ID)-----> corresponding query is "select first_name from employees where id = &id(user input)"

    Is it possible? Couldn't find much on web.

    thanks

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,812
    Location
    Moderator bump.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    VBAX Regular
    Joined
    Jan 2018
    Posts
    55
    Location
    Yes, it's possible if OracleClient is installed.

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
  •