-
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
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
-
Forum Rules