Results 1 to 4 of 4

Thread: SQL output from Excel VBA macro

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    May 2013
    Posts
    3
    Rep Power
    0

    Post SQL output from Excel VBA macro

    I have some requirement on excel macros.
    Suppose I have a table named "Employee" and schema named "HR" in ORACLE database.
    Schema name and table name should be in list-box (like attached pic).
    Now I want to display the selected columns output row after clicking "SQL" button like below image.
    Is it possible to do in excel macro?

    SQL_Excel.jpg

    example :
    If I select column c1, c2 and c4 from "HR"."Employee" table, in back end the query should fire 'select c1, c2, c4 from "HR"."Employee" ' from database. And these c1, c2 and c4 is not fixed I may increase or decrease column count from front end so It should generic.
    Last edited by goldenbutter; 05-02-2013 at 11:57 PM.

Similar Threads

  1. Upload Excel Data to SQL Table
    By littleiitin in forum Excel and VBA Tips and Tricks
    Replies: 3
    Last Post: 08-22-2012, 11:02 AM
  2. SQL in Excel
    By Nishant Choudhary in forum Excel Help
    Replies: 2
    Last Post: 01-24-2012, 05:55 AM
  3. Replies: 2
    Last Post: 11-17-2011, 07:49 PM
  4. Execute SQL From Excel (VBA)
    By Mechanic in forum Excel and VBA Tips and Tricks
    Replies: 8
    Last Post: 10-02-2011, 04:30 PM
  5. Execute SQL From Excel (VBA)
    By Mechanic in forum Excel Help
    Replies: 0
    Last Post: 05-13-2011, 10:27 AM

Posting Permissions

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