+ Reply to Thread
Results 1 to 7 of 7

Oracle Data Exp into Excel

  1. #1
    Registered User
    Join Date
    01-31-2008
    Posts
    4

    Lightbulb Oracle Data Exp into Excel

    Hi there,

    Somebody have any idea how can I upload my oracle data into excel sheet and I want to use parameters in excel.

    I have some idea I need to make connectivity through ODBC driver then I can pull data from excel through get external data option.

    Somebody can give me the appropriate steps how to that, below is my sql which I want to attach in EXCEL.
    Please Login or Register  to view this content.
    Kindest Regards
    Zeeshan Siddiqui
    Last edited by Leith Ross; 01-31-2008 at 12:39 PM.

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Oracle Data Exp into Excel

    Try this....

    Download the free QueryMaster file from Debra Dalgleish's website:
    http://www.contextures.com/excelfiles.html#External

    That file has an example of how to query an Oracle database.

    Does that help?
    Post back if you have more questions.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    01-31-2008
    Posts
    4

    Oracle Data export into excel

    Thank you for your reply Ron,

    Ron as per my knowledge because I am not a excel expert I need to make a ODBC connection then I need to put my query there and also I need to call parameters from instance:WHERE TRUNC(CR.date_of_disposition) between to_date('&p_from_date','DD-MON-YY') -- Here is my parameters.

    Can you please help me help me out how can I do this I need to know the steps.

    Thanks and apprechiate you!

    Zeeshan

  4. #4
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Oracle Data Exp into Excel

    Assuming you're using MS Query to construct the query....

    First, on the sheet to receive the data.....
    Select 2 parameter cells.
    Format them as TEXT
    Enter a start date and end date (in an Oracle format) in those cells

    This section of your SQL:
    WHERE TRUNC(CR.date_of_disposition) between to_date('&p_from_date','DD-MON-YY')

    Could be written with a parameter placeholder:
    WHERE TRUNC(CR.date_of_disposition) between to_date([strStartDate],'DD-MON-YY')

    When you initially run the query from MS Query, you will be prompted
    for the value of [strStartDate]. Enter a date that Oracle will
    understand (eg 01-JAN-2007) and the query will run.

    If you're satisfied with the returned data set...
    Click the button to return data to Excel.

    At the next screen
    Click the [parameters] button and select that you want the
    parameters be read from cells. Select each of the cells.

    When done....MS Query will use the dates you entered in the param cells in the query and return the appropriate data.

    Does that help?

  5. #5
    Registered User
    Join Date
    01-31-2008
    Posts
    4

    Lightbulb Oracle Data export into excel

    Hello Ron,

    Sorry for bothering you, whenever I try to connect with oracle db through ODBC it gives me the error 'OUT OF MEMORY' do you have any clue.


    Thanks and have a great weekend!


    Zeeshan

  6. #6
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Oracle Data Exp into Excel

    Can you link to any Oracle tables via ODBC using MS Access?

    If No, from a quick Google seach, it seems you may need to update your Oracle ODBC driver.

  7. #7
    Registered User
    Join Date
    01-31-2008
    Posts
    4

    Oracle Data export into excel

    Hi Ron,

    I can connect Oracle DB but I tried by best I could not adjust the parameters.


    Can you please give me the example how can I do that because I am not good in EXCEL.


    Thanks and apprichiate your help,

    Zeeshan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1